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

edited 12/09/19 in Archived 2016 Posts

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.




This discussion has been closed.