Formula Question

Hello - I need help getting a formula updated. I have the formula I currently have in the row pasted below. I want to add IFERROR into it so I don't have a bunch of cells that say #INVALID OPERATION. How do I add that into the formula I have below?

=[Session Date]@row - 25 + IF(WEEKDAY([Session Date]@row - 25) = 1, -2, IF(WEEKDAY([Session Date]@row - 25) = 7, -1))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!