I would like to create a column that tells me how many days since the last comment. Is there a way to do this?
You could try to use an auto column type to track last Modified Date on the row and then run a formula off of it to count days. But "Modified Date" will update any time any cell on the row is updated, not just a comment.
It could probably be set up with the help of a third-party solution like Zapier or similar.
Would that work?
Have a fantastic week!
Workflow Consultant @ Get Done Consulting
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.