Hi all, I'm trying to extract the first set of data in this single select field using LEFT() and then converting that into a date field. The data extracted will be in Chicago time. When I run this formula, it assumed that the date is in GMT, and doe...
Hi there,
I’m using airtable to compare an actual quantity with a goal quantity, then using an If, Then statement to tell me whether I’m at my goal, need to increase, or need to decrease my actual.
Here’s my current formula:
IF({% of total}={Goal % o...
Nevermind, I got around this with DATEADD instead. Still confused about SET_TIMEZONE, but since this is for a single weekend event, I shouldn't have to worry about DST and a static DATEADD should work fine.
Oh my gosh, OF COURSE! Thank you so much for seeing that. I would have been staring at the screen for hours more today. I knew I had to be missing something obvious!
Hmm, still getting the error with this:
IF(FLOOR(ROUND({% of total},0))={Goal % of total}, "OK",
IF({% of total}>{Goal % of total}, "Trim",
"Expand"))
I tried to make another column that just rounded the number so that I could make the formula sim...
Thank you!
When I try this:
IF(ROUND({% of total},0)={Goal % of total}, "OK",
IF({% of total}>{Goal % of total}, "Trim",
"Expand"))
It still returns Expand for 1.9 and a goal of 2.
My Goal numbers are integers, actuals are decimals, maybe that’s w...
