Formula help

0

Is there anyway formula that can pull from two seperate dates from on data point and us the most current date.

The one below Pulls a due date for GH01YM but there another data entry for a Waiver Date that I would like to use if that one has a more current due date. The second formula is what ive been trying to work on.....

Max(IF("Task ID" == 'GH01YM', "Due Date"))

 

Max(IF("Task ID" == 'GH01YM', "Due Date", "Waiver Dt"))

jesus.de_leon.3's picture
Joined: Sep 21 2021 - 7:02am
Last seen: 1 week 3 days ago

1 Answer:

0

The IF statement is a combination of “Test condition” , Value 1 (if true), Value 2 (if False).

if Due Date<Waiver Dt then  Waiver Dt  else Due Date

It‘s preferable to perform calculations and comparisons in query

bigalex's picture
107
Joined: Apr 12 2019 - 9:15am
Last seen: 1 week 14 hours ago
Feedback
randomness