Sign in to join the conversation:
Hello,
I am looking for a formula that will automatically change Green Status to Red Status when the date has expired?
Thank you!
You can use the below formula.
=IF([Expiration Date]@row < TODAY(), "Red", "Green")
Best Regards,
Nikhil Chawla
Just make sure that the status RYG column is locked. Any manual changes of the status column to any color will overwrite the formula. I highly recommend automating every color-way or none at all. The other drawback is if you want people to manually adjust a column in a report, formulas make those cells uneditable in the reports.
I just wanted you to be sure of the consequences!
Thank you Mike!
You're welcome!
I'm trying to create a formula that will output a Product category. Below is the formula and I've provided a screenshot of the columns involved. =IF(AND(Folder1 ="default", [Cost Category]1="Printer : Plex", ISNUMBER(FIND("Color",[Cost Option]1))), "Color Impressions", If(AND(Folder1="default", [Cost Category]1="Printer :…
Hi All, I have a project plan with a column called "Owner" that has a column type of contact list. The contacts are from multiple companies. It's a large project plan. I have created columns that have a column type of checkbox. I want to check the box if the owner is from a certain company (which can be determined by the…
I have an automated workflow set up to run weekly and request an update when the project is in certain statuses. The automation only ran once and now it's not working even though I have it set up to run weekly. I need help troubleshooting why this isn't working.
