The Community Search page is currently unavailable. We are investigating this and hope to have a fix as soon as possible. Please use alternate search engines (e.g. Google) or navigate to your profile to find individual posts. Thank you!

Determining a Weekday Start Day by Referencing a Calculated Field

Hello,

I'm trying to determine when to start a project based on the due date and the effort. The effort exists in hours and I've converted that into days based on a 7 hour day (padding days to allow for admin/other work in a day). This is my WORKDAY formula:

=WORKDAY(Stop109, [Effort (#Work Days)]109)

However, when I try to reference the "# Work Days" calculation in my WORKDAY formula, I receive the "INVALID DATA TYPE" error. If I hard key that value in the formula, the formula works. I have over 300 project line items that have varying efforts, so I need my formula to work with a reference to effort.

Any ideas/workarounds/etc?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!