Calculating Date Changes +/- In a Single Cell
I have a sheet where my client selects a "Requested Go Live Date" for their digital item to go into a catalog.
They often will go into that same row/cell and change that date. I have notifications for when that happens, but **I want a cell/row in which the number of days plus or minus from that change is captured based on the very first date entered into the cell.
Ex: Original go live date 10/01. They go back into the same cell and replace 10/01 with 09/25 - I'd like to have a +/- Days column that would be able to read/understand/tell me the Days +/- is [-6] because I just lost 6 days, for example. Any ideas on the best way to do that?
I know you can view cell history and see it, but not sure how to calculate on a changed value in a single cell.
Thank you
Answers
-
Hi @Jodi Mackie
I hope you're well and safe!
You could use the Baseline feature, but it would be set once, so if dates are added multiple times, it wouldn't work.
My suggestion would be to have a look at my post below with a method I developed.
More info:
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!