Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Creating a non-updating date

edited 12/09/19 in Archived 2017 Posts

This problem specifically references two columns - The first being a flag column and the second being a date column.  When the flag column is flagged, I would like the date column to get the date the flag column was flagged - and stay that date.  

Here is the formula I am using right now:

=IF([Flag Is Flagged]4 = 1, TODAY())

This isn't working because every day the flag column is flagged for that row, it updates the "Flagged Date" to be today.  I need the Flagged Date to *stay the date the flag was tuned on*, whether it was today, last week, or last month.  

Is there a way to get the current date ONCE, put it into a date field, and have it not update as the days pass? 

I've considered pulling the DAY(), MONTH(), and YEAR() out of TODAY, but the problem remains that as the date in today changes, so does the value in my "Date Flagged"  date column.  


This discussion has been closed.