Hello,
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.
Hi,
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!
Best,
Andrée Starå
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.
Comments
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.
Hi,
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!
Best,
Andrée Starå
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.