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.
Current date against a ticked checkbox.
I'm trying to come up with a formula that will populate a given cell with the current date if and when a certain checkbox has been ticked. Please note, this date must be fixed, i. e. it must NOT change as the days go by. Is this possible at all?
I know this is completely wrong, but just to illustrate better what I mean ("Done1" because the checkbox is in a column called "Done").
=IF(Done14, 1, "whatever would insert the date").
Further do this, there will be additional cells which are supposed to take that fixed date discussed above, add, say, 7 days to it and display the result.
Thank you kindly in advance for any and all replies.