Nested If statements

TZU

I am new here, but cannot figure out how to make a nested if statement or an automation to change the status based on a date in the past. What I would like to happen is when any of these dates are in the past AND the check box is not checked the current status will change to "DELAYED". I can get it to work for one argument but not the others at the same time.

I tried automation, but cannot figure out how to ignore the rows that do not have a date so it does not override what is already in the current status column. Thank you for all your help and hope this makes sense.

Screenshot 2025-03-06 at 10.26.43 AM.png

Uploaded Mar 6, 2025128.97 KB

Mark.poole

@TZU

For Automation. Just repeat this for each situation.

Mark.poole

@TZU

What are the different status and conditions you want. Ill build the formula and explain why it works to you

TZU

Thank you so much!

If any of the dates in Due from Corporate Partners is in the past and Received From Corporate Partners is not checked - or - Due to Copy Center is in the past and Sent to Copy Center is not checked -or - Due to Assembly Room are in the past and Copy Center Complete is not checked.

This is the argument that I would like to change Current status to DELAYED

but only if there is a date in any of the date rows. There are some without a date and I already have a status in the current status column?

hope this makes sense.

Mark.poole

@TZU
Well I can build an entire formula that can incorporate all the different statuses for you. If you would rather enter certain statuses manually. Then automation would be the best bet. To achieve the automation. Just have it search for the different date columns. and chose is not blank as the status. That will prevent from adding a date to the areas that you do not have dates in.

Mark.poole

@TZU

For Automation. Just repeat this for each situation.

TZU

That worked. Thank you so much. I was trying to do it off of date and did not even think to do it off of the check box.