Need to return max date - only if two criterias have been met otherwise left blank


I'm struggling to get this function right - I need to return the max date ONLY if the GCA approved and DAC completed column have a date otherwise left blank. This is what I have so far:

As you can see - a date is still being returned even if both columns don't have a date. It is only left blank if both columns don't have a date.

Appreciate any help or tips! I'm new to smartsheet.

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓

    Hi @Ashlynn,

    This formula should do what you'd like:

    =IF(AND(NOT(ISBLANK([GCA Approved (Date)]@row)), NOT(ISBLANK([DAC Completed (Date)]@row))), MAX([GCA Approved (Date)]@row:[DAC Completed (Date)]@row), "")

    Some example data:

    Hope this helps; any questions etc. then just ask! ☺️


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!