I have columns called Refresh Due and Refresh Priority and I want the results in these columns to provide a result in a third column called Priority Order.
Refresh Due is a calculated column that references warranty dates and provides the result- "Due" or "Still Under Warranty".
Refresh Priority is a Yes or No choice column (this column is if I want to prioritize a refresh of an item before its due).
I want Priority order to display 1, 2 or 3, number 1 being top priority
- Refresh Due = "Due" Refresh Priority = "No" - Result "2"
- Refresh Due = "Due" Refresh Priority = "Yes" - Result "1"
- Refresh Due = "Still Under Warranty" Refresh Priority = "Yes" - Result "1"
- Refresh Due = "Still Under Warranty" Refresh Priority = "No" - Result "3"
I have gone through google searches and suggested links on here but not found a result that works, I have tried the following which gives me one or two results but not all of them.
This one I found online but fails syntax:
=IF([Refresh Due]="Due","2",IF(AND([Refresh Due]="Still Under Warranty",[Priority Refresh]="Yes","1"),IF(AND([Refresh Due]="Due",[Priority Refresh]="Yes","1","3"))))
This one only partially works, will change from 2 to 1 but dependent only on the Refresh Due column, the Refresh Priority has no effect:
=IF([Refresh Due]="Due","2",IF(AND([Refresh Due]="Still Under Warranty",[Priority Refresh]="Yes","1"),IF([Refresh Due]="Due",[Priority Refresh]="Yes","1")))