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.
Conditional Operations on Read Only Fields when Record is Modified
Scenario
Two Fields
Responsible
Date Closed (read only)
Requirements
1) When the record is updated, if Responsible equals "Closed", automatically populate Date Closed with TODAY()
2) When the record is updated, if Responsible does not equal "Closed", automatically populate Date Closed with blank
What tools/methods can be used to satisfy these requirements?
Comments
-
Hello Max—You could use an IF formula that will populate the current date as long as your "Responsible" field is equal to "Closed." An example of what this might look likeis as follows:
=IF(Responsible1 = "Closed", TODAY())
Keep in mind that this will continue to populate the current date as long as the condition is met (in this case Responsible being equal to "Closed") and we don't have functionality to return only the date a specific value was entered in a cell.
-
Max,
This will work if the row is not updated after closure:
=IF(Responsible1 = "Closed", MIN(Modified1, TODAY()))
You can add a notification when the Responsible column changes for an Admin user to lock the row -- but that only protects against non-Admins
Hope this helps.
Craig
-
Is there a way to add date AND time?
