Formula Help

Options

I have a system generated column for the Created Date. I have a Due Date column that I am trying to calculate the Created Date = 1 Business Day. Here is my formula: =WORKDAY(DATEONLY([Created Date]@row) + 1).

I need to strip the time stamp from the created date which is why I am using the DATEONLY function but I am trying to get the formula to account for adding 1 business day (why I am using the WORKDAY function). I am getting an Incorrect Argument error. What am I missing?

If a request is added on a Friday I want the Due Date to reflect the next Monday (1 business day) as the due date.

Answers

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Options

    Hey @jennifer.jessop44491

    You almost had it!

    It's incorrect argument set because WORKDAY expects at least (2) arguments and you just gave it one (the date) and then tried to add one. See below.

    =WORKDAY(DATEONLY(Created@row), 1)

    Let me know if that solves your problem or if you need any more assistance!


    -Jon Mark

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!