Problem with nested IF statement


#1

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?


#2

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