Hi All!
I have a nested IF statement that is set up to find if the value from Column A, B, C, D, or E matches Column F. If one matches, it produces the name of the column. What I’m looking for is a way to produce more than one name if more than one c...
I currently have an IF statement formula nested into a longer SWITCH formula, and am looking for a way to modify it some. Currently it is
IF({Total Order Sold Price} < 15, 2.95,
IF({Total Order Sold Price}>= 15, {Sold Price} * .2))
I want to first ch...
I have a field that includes a number range for each record: “5-10”, “15-20”, etc. On another table, I would like to do a rollup that adds together all the first and last numbers in those ranges, displaying “20-30” essentially. Is there a rollup form...
I have a rollup field that is pulling the sum of multiple numbers, and in the next field, I want to use that result in a formula, but am getting an error. Before it was a rollup and I just manually entered the number, the formula field worked fine, s...
Hi all! I’m looking for a solution in a switch formula, with nested if functions.
I want to calculate a percentage & addition based fee that changes based on the category input. Also with possible caveats on how that fee is calculated based on the pr...
‘’@megan_sellheim
Found it!
Airtable Support
Multi-source syncing
Multi-source sync allows you to bring information from multiple sources into a single, centralized destination table. The records residing in each of ...
I know this is old, but if I use this formula, do you know if there is a way to have it only display the ‘MMM’ in the field rather than both ‘MM’ & ‘MMM’?
Oh my gosh, I completely missed that I didn’t update the first {COG} pull to the new {Total COG} pull, so it was pulling from the wrong column :woman_facepalming:
Now I feel silly, it does work.
Thank you for your help!
This is the rollup formula:
Here are the values it’s pulling from and the results.
And here is the field with the formula I used above that should be using those 2 fields for its calculation
