Max Collect formula help

Lauren Dobkin

Hello

I can't seem to troubleshoot this formula. Return the latest date [Planned Date Completed] associated with "1" [SOW Billing sequence]. Any idea why it's returning 0?

Thank you!

Lauren

Leibel S

@Lauren Dobkin

Are they both date columns?

Lauren Dobkin

Hi @Leibel Shuchat One is a date column and one is numerical, not a date.

Leibel S

they both need to be date columns for it to work and all the values in [Planned Date Completed] need to be dates

Lauren Dobkin

Very helpful. Thank you @Leibel Shuchat I guess I'm not using the correct formula then. What formula will return the max date if SOW billing sequence = 1 ?