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

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.

Find more posts tagged with

Formulas

functionality

Accepted answers

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! 🙏

Vishnu Kayarat

https://community.smartsheet.com/discussion/comment/400199#Comment_400199?utm_source=community-search&utm_medium=organic-search&utm_term=cell+history

I have upvoted this idea.

All comments

Andrée Starå

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

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

Vishnu Kayarat

Thanks Andrée. I'll submit this as a feedback.

Vishnu Kayarat

https://community.smartsheet.com/discussion/comment/400199#Comment_400199?utm_source=community-search&utm_medium=organic-search&utm_term=cell+history

I have upvoted this idea.

Andrée Starå

Excellent!

Happy to help!

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.