Latest Date in a column

I have set up an automation to set the last updated date in a column on a project plan. I want a formula that will reference the project plan last updated column to show the last date the project plan was updated. I am using the following formula:

=MAX({Project Plan Range 1}:{Project Plan Range 1})

I'm getting a #UNPARSEABLE error. I'm sure it's something super simple that I'm not doing but have tried square brackets etc. and nothing seems to work.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!