Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Problem with nested IF statement

Topic Labels: Formulas
590 1
Showing results for 
Search instead for 
Did you mean: 

I’ve been reading the board attempting to properly formulate a nested IF statement, but I keep getting an invalid formula error. Could someone please help? This is what I’m trying to do: each record of my database entries are defined by either being Open, Billed or Paid. I use a multiple select drop down to mark the record. What I would like to do is have a field serve as a time stamp for when the condition changes from one to the other. This is the formula I have so far, but it is not working:

IF({Status}=“Open”,DATETIME_FORMAT(NOW(), ‘MM-DD-YY’), IF({Status}=“Billed”,DATETIME_FORMAT(NOW(), 'MM-DD-YY’), IF({Status}=“Paid”,DATETIME_FORMAT(NOW(), ‘MM-DD-YY’))))

What am I doing wrong?

1 Reply 1

Oops. Solved it myself. Nothing was wrong with the formula. It was the CURL QUOTES that were causing the error. :slightly_smiling_face: