What am I missing in the formula?
Here is the scenario:
Column 1 is the harvey ball symbol status - empty, quarter, three quarter, full
The goal is that each time one of the other columns is filled in with any date or a checkbox tick that the status changes.
Here is my current formula:
=IF(NOT(ISBLANK([Date Received]@row)), "Quarter", IF([CA Review Complete]@row = 1, "Half", IF([CA Approval Complete]@row = 1, "Three Quarter", IF(NOT(ISBLANK([Date Completed]@row)), "Full", IF(ISBLANK([Date Received]@row), "Empty")))))
The problem: it will only do one action at a time. It does not build. So if a date is filled in, the status changes to quarter, but if then the next column is ticked it does not change to half. If i delete the date then it will go to half.
Any help is greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!