Why does the column 'Most Recent Date' returns blank when I use the formula Max?

Maei
Maei ✭✭
in Formulas and Functions

I am trying to get the most recent update date using Max but it shows blank (no value) upon entering.

image.png


· Share on FacebookShare on Twitter

Answers

  • Khasim
    Khasim ✭✭✭✭✭

    Hi @Maei

    Please use =Max(Children()) and ensure that the column property is a Date.


    Thanks & Regards

    Khasim

    SSPM Consultants

    Email ID: info@sspmconsultants.com

    Did I answer to your question or fix the problem? Please help the Smartsheet Community by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!