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 have a to do list with parent tasks and children tasks. I have a status column with a dropdown menu with the options “Not started,” “In process,” and “Completed.” I want to have a formula that auto-populates the parent task with the status based on the children tasks. Here is the logic that I want the formula to use: If…
I have a parent row that I'm using to sum all child row values where Children = 0 and Status = "Not Started". This is my formula. =IF(OR(ISBLANK(Status@row ), Hierarchy@row = 0), "", IF(Hierarchy@row = 1, SUM(CHILDREN()), IF(AND(Children@row = 0, Status@row = "Not Started"), 1, 0))) However, if any of my task rows are…
Hi, I am trying to get a column that provides the Date (easy with Record a Date) but I need the TIME as well. Most of my tables I just use the right function on the Modified Date because the only thing updating those tables are automations or data imports. But a few tables have automations, data imports, and manual inputs.…
