Skip to main content

Remove #Error when field isn't filled out

  • August 8, 2019
  • 3 replies
  • 35 views
C

Hello,

I am using the WORKDIFF formula to calculate the difference between workdays.

This is formula is this:

WORKDAY_DIFF({Date Started}, {Date Finished})

But I’m getting the #Error when the “Date Started” isn’t filled out. Any suggestions? Thank you!

    This topic has been closed for replies.

    3 replies

    C
    • Claudio
    • Participating Frequently
    • August 8, 2019

    Try this:
    IF({Date Started},WORKDAY_DIFF({Date Started}, {Date Finished}),“No Date Started”)

    To include a check for Date Finished, you can use this:
    IF({Date Started},IF({Date Finished},WORKDAY_DIFF({Date Started}, {Date Finished}),“No Date Finished”),“No Date Started”)

      C
      • Catherine_Murp1
      • Author
      • New Participant
      • August 8, 2019

      Thank you! It was throwing an error, so I removed the " (quotes) replaced with ’

      IF({Date Started},WORKDAY_DIFF({Date Started}, {Date Finished}),‘No Date Started’)

      and this one:

      IF({Date Started},IF({Date Finished},WORKDAY_DIFF({Date Started}, {Date Finished}),‘No Date Finished’),‘No Date Started’)

      Thank you for your help!

      C
      • Claudio
      • Participating Frequently
      • August 8, 2019

      I see that when you paste my formula the quotes are being changed to smart quotes: the first one goes up to the left, and the second one goes up to right.
      You can still use double quotes if you type them directly into the formula, or you can type single quotes, as you did.
      Glad it worked.

      Terms & ConditionsAccessibility statement