This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Morning, Was wondering if someone could help me out here. I'm trying to
wrap my head around a formula I am trying to get to work but seem to
have some problems. I got two drop down list at the top of my form. Once
the first on is select, the second o...
Hello. I was wondering if someone can point me in the right direction
here. These formula's are a little different the excel's. So I really
frustrated on make a these formulas work. First formula is
Select(equipment[unit], ( [_thisrow].[type of filte...
Hello,Little lost here. Wondering if someone could help me out. I have
this formula which works great but I have manually select the values I
want as it show the whole column. Is there away where this formal can
modified to auto select the values tha...
Hello, I am kinda lost here. Here is what I am trying to do. I want to
use a select formula based on values entered in a form, then look for
values that match it. I like to either use dropdown list or user input
value. Here's my Example. FormType of ...
Hello, Wondering if someone could help me here. I am looking for a
formal for my app stateing once a value is selected, then find the
column or header it is in the table, then post the name of that column
or header. Thank you in advance. Jason
Thank you Aurelien, OMG, I added false at the end and changed the select
column. Just what I was looking for. I just want to say thank you so
much, it's going to be a long code once I am done adding the other
columns to it but it's what I have been p...
Hello Aurelien, I tried both of these formulas but I keep getting an
error "Number of opened and closed parentheses does not match." I can't
seem to fix it. Any suggestions?Thank you again for the helping me out.
Good Day Aurelien,Sorry for the mass confusion, The values that I want
to catch is from another table, and only want the catch values the are
affiliated to the part number once it's determined in that it's under
the "Type of Filter" Column. That drop...
Hello Steve, Thank you for your reply back. I have a master equipment
list that breaks down what type of filter and their part number. In the
master sheet the "type of filter" Eg Engine oil filter, Fuel filter.
Hydraulic filter. Ect. Column list go o...
Hello, On a earlier post "Can you use a dropdown list in a select
formula",WillowMobileSys helped me that when I used my dropdown on "type
of filter" that "parts number" value would show the filters that
associated with the type of filter. Now what I...