I consider myself a fairly adept user of Airtable, but I think this question is going to say otherwise.
My objective is to see this (the red dollar sign represents my Job Cost field):
So on a calendar view, I want to see a concatenation of the Compa...
This is probably a stupid question, but why is my result not a number in the following If statement?
IF({Course Order}>0,{Cost-1st Attendee}+{Cost-2nd Attendee}+{Cost-Additional Attendees}, “”)
It actually works, but I can’t format it, and the Summar...
Jason,
That is awesome, and the second one works exactly like I need it to. I’m not sure I understand exactly why it works (not at all familiar with the AND option, but i’ll continue to study this until I get it), but I’m really good and monkey see, ...
Thanks Jason, that was helpful. I just ended up adding a second number field that I fill in manually based on the Lookup field, and I’m able to use that in my formula, and keep my data sets (Tables) separated and fairly simple (If I added all the Pro...
