Problem with 'workday' formula

La19 · 08/11/20

I can't seem to get the following formula to work in my smartsheet - it is referencing a column with dates in it:

=Workday([Due Date]76,5)

What am I doing wrong? When I type it in, it just treats the syntax as text.

Thanks!

David Joyeuse · 08/11/20

Hi Laura,

At first I would check if your formula is in a Date type column.

Andrée Starå · 08/11/20

Hi @Laura19

In which column are you trying to add the formula?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

La19 · 08/12/20

https://community.smartsheet.com/discussion/comment/259442#Comment_259442

Yes, I'm trying to use the formula in a Date type column. How does that impact the formula?

La19 · 08/12/20

Update: I think I figured out the problem. I hadn't used this smartsheet in awhile. The 'start' column in which I was trying to put the formula had dependency settings that referenced a 'predecessor' column (which I had not updated) which is supposed to list the previous row and a 'duration' column which calculates the number of days between the previous row's start and due date.

Thank you for the previous answers!

Andrée Starå · 08/12/20

@Laura19

Happy to help!

Glad you got it working!

Problem with 'workday' formula

Answers

Categories