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?