How to use previous cell value (from cell history) in a formula?

Vishnu Kayarat

I have seen this question asked multiple times in the forum, but I couldn't find any clear answer provided in the answers. Please excuse me if a solution already exists, but if not, will someone please let me know if it is possible to use a previous cell value (from cell history) in a formula?
I am specifically trying to retrieve the previous date that was entered in a cell, and based on if you have a value or not (i.e, if the date was changed), trying to record the new date in a separate column in the sheet.

Andrée Starå

https://community.smartsheet.com/discussion/142912/how-to-use-previous-cell-value-from-cell-history-in-a-formula

Hi,

I hope you're well and safe!

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit this as Product Feedback or an Idea (If it hasn't been added already) when you have a moment.
Feel free to share the link to the Idea here so that others and I can add our votes.

Here's a possible workaround or workarounds

Please review the post below, which outlines a method I have developed.

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏