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.

Mixing overwrite with formula

Joshua Rose
edited 12/09/19 in Archived 2017 Posts

Hi-- so, I have a wonderful formula in a cell whereby depending on the dropdown choice selected in another cell, X, Z, Y occurs in the cell where the formula resides.


What concerns me is that sometimes a situation may occur where overwriting that formula is temporarily necessary. But we don't want to lose the formula there forever. Once one of those dropdown choices gets selected again, we'd like it to reassert the formula.


Any way to do this? Can I have a cell at the end of the spreadsheet, for example, that says:


=IF([Eval Interview Status]1 = "Pending", [Next Client Contact Deadline]1 = "[Referral Date]1 + 2")


whereby if Pending gets chosen from the dropdown of one cell, the referral date + 2 gets applied to Next Client Contact Deadline. And then we could overwrite in Next Client Contact Deadline. But if we re-select Pending later, the original formula re-applies??? 



This discussion has been closed.