Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Need Help using the function WORKDAY
Options
Lund
✭✭
Hi there,
I'm trying to use the function "WORKDAY" in order to have an end date output, based on a calculation, but when the "number_of_days" value is not a whole number, the formula returns an error. How do I have the formula always round up? Is it possible to mix the formula with the function "ROUND" with 0 digits?
Thank you.
/Lund
Tags:
Comments
-
This formula should do it...
If(number_of_daysX - Round(number_of_daysX) > 0, Round(number_of_daysX) +1 , Round(number_of_daysX) )
This discussion has been closed.