Hi All, I am trying to get a function to enter the current date when I change the status to done but I want the date to stay static and I cant figure out what date function to use for this. Here is what I have:
IF(Status=“Done”, DATETIME_FORMAT(TODAY(),“DD/MM/YYYY”), BLANK())
Now when I changed one item to “Done” yesterday it put in yesterdays date but when I logged in today it had todays date instead. I figured this would happen but don’t know what to put where I have “TODAY()” to get this to work.
Can anyone help me with this?