Nested IF formula with If/And

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

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.