Can I make a form demand EITHER field be required?

Hullo:

I am using a form to track outside vendor shipments.

Sometimes our shipping team gets stuff into the system in advance, sometimes after it's been picked up.

I would like a form that requires either Estimated Ship or Actual Ship. If one is filled, the other doesn't need to be, but at least *one* of them must be filled. (There is an automated workflow in place to remind for actual ships to be filled in later on if they use estimated at the top.)

Is there a logic or dependency option on forms to make that work?

Tags:

Best Answer

  • Bill Sjolinder
    Answer ✓

    The only way I could think of this to work is to do the following.

    3 fields.

    The 1st asks either Estimated or Actual. From there, it is logic based to pull up the follow on field that matches up with the answer to the 1st question.

Answers

  • Bill Sjolinder
    Answer ✓

    The only way I could think of this to work is to do the following.

    3 fields.

    The 1st asks either Estimated or Actual. From there, it is logic based to pull up the follow on field that matches up with the answer to the 1st question.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!