Multiple IF/AND statements
Trying to combine the following formulas based on changing criteria and not sure how to put them together. Each one works on it's own but as soon as I try to add another one I get an #UNPARSABLE error.
IF(AND([Vendor Assignment]@row <> "", [Window End]@row = ""), "Vendor Assigned", "")
IF(AND([Vendor Assignment]@row <> "", [Window End]@row <> ""), "Site Survey Scheduled", "")
IF(AND([Window End]@row < TODAY(), [Date Survey Received by Internal Team]@row = ""), "Late - Requested Update", "")...on a side note on this formula, want to figure the date as 3 days less than today.
Not sure if I need to add an OR somewhere. Any assistance would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!