Modified Date Corresponding to One Column ONLY
Hello all! A question about a formula and/or Modified Date System Column. In my task list, I have a column marked "Due Date." Our team may extend that due date, and my manager would like to keep a record of when the due date was modified. I was wondering if it was possible to have the system column "Modified Date" only correspond to one single column. Alternatively, is there a formula that could help keep track of this that I could then send to a report or sheet summary? Thank you!
Answers
-
I don't believe so. However, you can right-click on a cell and choose View Cell History to see what it was changed from and to and by whom and when. So you should already have what you need.
-
Hi @Andrew R.
I hope you're well and safe!
To add to Matt's excellent advice/answer.
Here's a possible workaround or workarounds
- You could check the Activity Log.
- Please 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 weekend!
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 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.
-
It turns out that my manager no longer needs this! Sorry about all that. With that said, @Matt C. and @Andrée Starå thank you for the solution! I will say, I'm new to the more complex formulas, so I may need some visual walk-throughs as you explain :)
On a related note, the sheet I was referring to in my OP is a separate sheet from my normal "To Do" list. There are three columns that are listed on that sheet as "Due Date," "New Due Date," and "Due Date After Revision." I would like not to have to worry about updating my due dates twice, so I was wondering if, when a new due date is added to the latter two columns, would I be able to use the VLOOKUP function to change the due date on my sheet?
I appreciate your patience and help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!