Help with IF(AND) function

Kblake

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.

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

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

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?