Need Help with a Formula Again

Options

Ok Team,

I am trying to say the following:

If APP SUB TO CVO/MSO]@row is blank then Grey

If APP SUB TO CVO/MSO]@row - [FACILITY HANDOFF (FHO) DATE]@row is less than 7 days then Green

If APP SUB TO CVO/MSO]@row - [FACILITY HANDOFF (FHO) DATE]@row is between 7 and 10 days then Yellow

If [APP SUB TO CVO/MSO]@row - [FACILITY HANDOFF (FHO) DATE]@row is more then 10 days then Red

With the ones that are in between I get an return of an incorrect argument

Sorry that I stink at formulas but below is what I put in

=IF([APP SUB TO CVO/MSO]@row = "", "Gray", IF([APP SUB TO CVO/MSO]@row - [FACILITY HANDOFF (FHO) DATE]@row < (7), "Green", IF([APP SUB TO CVO/MSO]@row - [FACILITY HANDOFF (FHO) DATE]@row > (10), "Red", IF(AND([APP SUB TO CVO/MSO]@row - [FACILITY HANDOFF (FHO) DATE]@row < (10), -[FACILITY HANDOFF (FHO) DATE]@row < (7), "Yellow")))))

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!