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:
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.
Why not have just the last modified time field without the automation? If you need the field to be blank when the status is not done, do that with a formula field that shows the last modified time only when the status is done.