Date formula not adding days

Jenn Burk
Jenn Burk ✭✭✭
edited 06/23/22 in Formulas and Functions

I'm trying to add "days" to a Date.

The formula in the "Test" column is:

=[Ex Works]@row + (IFERROR(INDEX({business days}, MATCH(Location@row, {location}, 0)), ""))

This is the error that I'm getting. I'm not sure what I'm doing wrong.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!