Summary Field return symbol for most recent entry


Hi, I've been searching and testing without much luck.

I have a task list that the project health is updated with each task. I added a column for last modified date.

I would like to have the summary field reflect the health on the row where the most recent modified date is. This summary field will be collected in a summary report across multiple sheets that in turn will be charted on a Dashboard for leadership to see the current health of various projects as of the last update. (In theory this sheet will be updated monthly.)

I've been trying combinations of INDEX, COLLECT, MAX to no avail. Even a simple =MAX(Modified:Modified) produces an invalid column name error. Any help would be appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!