using a calculated number of days in a workdays formula

Hi Im new to smart sheets - so thx for helping newbie

Im trying to drive a planned finish date

i use the workdays formula - grab the planned start date, then try to add the number of days from a calculated field (called Suggested Number of Days)  which calculates a number of days based on some inputs (e.g. 100/10 = 10)

but i get the #invalid data type error

however if i enter 10 into the Suggested Number of Days field (no formula), the error is replaced with the correct future date

is there a way to use the "calculated field" in my workday formula

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!