Extract Cell History For Formulas
Hello,
Is there any way to extract the Cell history to calculate formulas.
What I am trying to do is create metrics off the dates in the cell history. I.E. if a Dropdown list column starts on July 1 with Value 1 and changes to Value 2 on December 10th then Value 3 on December 21st. I want to measure and tract the time spent between the changes.
Thank you.
Brian
Comments
-
Hi Brian,
Unfortunately, it's not possible to access the cell history data in the sheet at the moment, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
A possible workaround could be to use a third-party service like Zapier or maybe it could work with the Smartsheet API.
Would any of those options work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Brian
I have devised a workaround when I wanted to calculate how long it took each approver to approve the workflow.
My solution was to create a separate secondary sheet for every approver and use a cross sheet reference from my main sheet to update the secondary separate sheet. The secondary separate sheet only contained the approval column “with cross sheet reference formula” and a system “modified” column that updated automatically as the approval in the main sheet was changed. I then inserted a column in my main sheet that cross sheet referenced the “modified” date from the secondary sheet.
Finally I had the date when the approval was made and could calculate the duration from the previous approval or the created date in the main sheet.
Hope you can make sense of my explanation for your application.
Good luck
Emlyn Childs
-
Hi Emlyn,
Nice workaround!
Thanks for sharing!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Emlyn,
I love this work around. It will take a TON of setup on our side. But this solves soooooooooooooo many issues right now. Thank you so much for answering.
Brian Hope
-
Is there already an enhancement request for this? If so, I want to vote for it! Please advise how to find it, if it exists. Otherwise, I will create a request... I think many people want to be able to have the cell history referenced in either a formula or another cell within a sheet.
-
Hi Chelsea,
There isn't any public list available of the enhancement requests already submitted. You can add a new one or vote for something that's already in another post, but you'd have to submit a new enhancement request for both scenarios.
Please submit an Enhancement Request when you have a moment.
A New Way to Submit Your Feature Requests
To make your Enhancement / Feature Request count, send in the form above because there isn’t a guarantee, it will be registered otherwise.
Original Post: https://community.smartsheet.com/announcement/new-way-submit-your-feature-requestsHope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi,
Has this been implemented yet? Any update?
Thanks!
-
Nope, Still would be nice to have and not have to pay for an outside tool that charges each time it runs.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!