I am needing help with a formula that includes multiple dates and criteria.
I'm needing help with a formula I can use to verify the last submitted entry "Created Date" that matches my "Identifier" and Projected End Date is not blank, I want to collect the "Projected End Date" or if the Projected End Date is blank on the last entry I want to collect the "Class End Date" for that "Identifier".
Here are the column keys I'm referencing:
My identifier column is: "Identifier"
Date to collect if the Projected End Date is not blank in the last submitted entry for that identifier: "Projected End Date"
Date to collect if Projected End Date is blank for the last submitted entry matching the identifier: "Class End Date"
The date referencing the last entry created and matches the Identifier criteria is: "Created Date"
Here is the formula I'm using that isn't working:
=IF([Projected End Date]@row = "", [Class End Date]@row, COLLECT([Projected End Date]@row, Identifier:Identifier, CONTAINS(Identifier@row, @cell), MAX([Created Date]:[Created Date]) <= TODAY()))
On another note, I want to collect that date and house it under a specific row within that identifier that matches day 1. I created a column for this date which is called: "Actual End Date".
Please let me know if you have any questions, I would greatly appreciate any help offered. Thank you.
Help Article Resources
Check out the Formula Handbook template!