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"))

BFuller

Hi…thank you for this. It almost works. Right now the formula is only putting a managers name if the created date is on or before the date I specify. How do I get the formula to run on assignments added after 12-16-2024?

Basically I need Manager B's name if it was before 12-16-2024. For everything after 12-16-2024, I need it to determine which manager's name to put based on who the PCD assigned@ row is. Can you help?

Paul Newcome

How about 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"), "Manager B")