Help with IF(AND) function

I have been trying to figure out where the issue(s) with my formula is awhile. I have tried to break the formula down in sections too, that didn't help. Is anyone able to help with my formula?

What trying to do use RYG symbols:

Refer to the Stage of Project Column, IF = Kick-off AND Wait List & PM Assignment = "" (blank), then leave blank. IF Stage of the Project = Kick-off AND Wait List & PM Assignment < TODAY (15) then Red, IF Stage of Project = Kick-off AND Wait List & PM Assignment < TODAY (-7) then Yellow, IF Stage of Project = Kick-off AND Wait List & PM Assignment is TODAY, then leave blank, Green.

Formula:

=IF(AND([Stage of the Project]@row = "Kick-off", [Wait List & PM Assignment]@row = “”)), “”, IF(AND([Stage of the Project]@row = "Kick-off", [Wait List & PM Assignment]@row < TODAY(-15))), "Red", IF(AND([Stage of the Project]@row = "Kick-off", [Wait List & PM Assignment]@row < TODAY(-7))), “Yellow”, IF(AND([Stage of the Project]@row = "Kick-off", IF([Wait List & PM Assignment]@row > TODAY()))), “”, “Green”))))

I am still fairly new to Smartsheet, sorry if my formula is completely off. Any help would be greatly appreciated.

Find more posts tagged with

Accepted answers

Paul Newcome

Try this instead:

=IF([Stage of the Project]@row = "Kick-off", IF([Wait List & PM Assignment]@row< TODAY(-15), "Red", IF([Wait List & PM Assignment]@row< TODAY(-7), "Yellow", IF([Wait List & PM Assignment]@row> TODAY(), "Green"))))

All comments

Paul Newcome

Try this instead:

Kblake

Thank you so much! It worked and is much simpler! I have been fighting with the formula for two days!

Kblake

I spoke too soon. I no longer am getting the #UNPARSEABLE error, but it isn't providing the results. If the Stage of the Project is Kick-off, it isn't resulting in the RYG dot in the column with the formula.

Kblake

I should have gave more context. The Stage of the Project is Kick-off, the date in Wait List & PM Assignment is more than 15 days in the past, it should return a Red dot, the cell was blank.

Paul Newcome

Can you provide a screenshot of the formula open in the sheet as if you are about to edit it?

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.