Changing column Property Status (Red, Yellow, Green) when two columns dates are different

I am in need for the status colum 1 (red, yellow, green) to automatically change when column 2 (date) is passed column 3 (date). Can this be done with a formula?

I can do "=IF([Approved Required Delivered Date]1 < [Adjusted Delivery Date]1, "Red")", however, I am sure on how to add the other two conditions in the formula.

Thank you,

Find more posts tagged with

Formulas

Product Development

Project Management

Comments

Andreas S.

Hi Roberto,

try this:

=IF([Date1]@row < [Date2]@row; "Red"; IF([Date1]@row = [Date2]@row; "Yellow"; IF([Date1]@row > [Date2]@row; "Green")))

Regards

Andreas

Roberto Sanchez

Andreas, I tried your recommendation; however, it is coming up with a #UNPARSEABLE message. This is what I entered:

=IF([Approved Required Delivered Date]1<[Adjusted Delivery Date]1,"Red"; IF([Approved Required Delivered Date]1>[Adjusted Delivery Date]1,"Green"; IF([Approved Required Delivered Date]1>[Adjusted Delivery Date]1, "Green")))

Andrée Starå

Hi Roberto,

Try this.

=IF([Approved Required Delivered Date]1<[Adjusted Delivery Date]1,"Red", IF([Approved Required Delivered Date]1>[Adjusted Delivery Date]1,"Green",IF([Approved Required Delivered Date]1>[Adjusted Delivery Date]1, "Green")))

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Roberto Sanchez

Thank you. It worked.

Andreas S.

Does this mean different languages have to enter Formulars different?

Andrée Starå

Excellent!

Happy to help!

The reason it didn't work was because you mixed commas and semicolons. It's different depending on the region.

Andrée Starå

Yes, that's correct! Different regions use different characters.

Andreas S.

That's a nightmare.

What when I share a sheet to a different region?

Andrée Starå

When you share with another region, they will see it in their format and can add/update with their format, so it's not that big of a deal.

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…