How to copy the latest comment in a row to a cell?

summetg
summetg ✭✭
edited 05/04/22 in Formulas and Functions

Hi all,

I'm building a new sheet where we want to use the comments function, but I'd like to have a "read only" of the latest comment left by a user and with the time a date in a cell. This would help summarize the latest detail on a report or a first look at the sheet, and then if they want to check the history they can go into the comments tab.

The intention would be to be a quick update summary in 1 row. Any ideas on how to achieve this? I did a few searches and it seems like it could be an enhancement request

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!