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

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!