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

Ashlynn

Hello!

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.

Nick Korna

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! ☺️

Nick Korna

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! ☺️

Ashlynn

Perfect! Thank you @Nick Korna!!