Help

Problem with nested IF statement

Topic Labels: Formulas
947 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Gerard_Swientek
4 - Data Explorer
4 - Data Explorer

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
Gerard_Swientek
4 - Data Explorer
4 - Data Explorer

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