Nested IF formula with If/And

BFuller

Hello,

I have the following formula that works, I just can't figure out how to include the date qualifier. Can someone please help? Thank you in advance!

If the assigned PCD is one of two people, I need my manager column to read Manager A's name. If it is anyone else, I need it to show Manager B's name. I want to add that this only applies to assignments that were added on or after December 16, 2024.

=IF([PCD assigned]@row = "PCD 1", "Manager A", IF([PCD assigned]@row = "PCD 2", "Manager A", "Manager B"))

Paul Newcome

Try this:

=IF([Date Column]@row >= DATE(2024, 12, 16), IF(OR([PCD Assigned]@row = "PCD 1", [PCD Assigned]@row = "PCD 2"), "Manager A", "Manager B"))