Using If And with symbols

Hello,

I'm currently trying to write a formula and am running into issues. I've added a "Project Health" column with red, yellow and green symbols. I would like these to change automatically using the following cells to determine.

If "Arrival Date" is blank, and "Customer Requested Delivery Date" is within 2 weeks, red

If "Arrival Date" is blank, and "Customer Requested Delivery Date" is within 4 weeks, yellow

Everything above 4 weeks can remain green. If the arrival date is entered, it can change to green.

Thank you in advance for the help!

Find more posts tagged with

Accepted answers

All comments

jjg279

Try this in your symbol column

=IF(AND(ISBLANK([Arrival_Date]@row ), [Customer_Request]@row < TODAY(14)), "Red", IF(AND(ISBLANK([Arrival_Date]@row ), [Customer_Request]@row < TODAY(28)), "Yellow", "Green"))

steve.messer84

Thank you so much! I ended up using the formula below and it seemed to work as well. Any benefit to one over the other?

=IF(AND([Arrival Date]@row = "", [Customer Requested Delivery Date]@row <= TODAY(14)), "Red", IF(AND([Arrival Date]@row = "", [Customer Requested Delivery Date]@row < TODAY(28)), "Yellow", "Green"))

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.