Nesting Formula for RYGB


Can anyone help me with a nested formula:

I need the date to populate if the RYGB is yellow or red only.

Formula works for one if I "not" green, but I want it to be if not green or not blue: =IF([Exposure Category]2 <> "Green", [Last Date of Exposure]2 + 15, "N/A")

Can anyone help?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!