index / collect questions...

I'm trying to figure out how to find the last update in a column. The column does not always get updated when other columns do. I saw some similar looking formulas like =INDEX([Date/Time]2:Location10, MAX(COLLECT([Date/Time]2:[Date/Time]10, Location2:Location10, <>"")), 7) but they don't seem to work for me - i get invalid data errors.

I am not sure if i am even approaching this correctly - any help would be appreciated!!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!