Relative Default Date in Forms

Options
Carmen Wong
Carmen Wong ✭✭
edited 04/29/20 in Smartsheet Basics

I'm looking to do a 'Needed by' date in a form and I would like the default to be a relative Today + 2 weekdays. Anyone found a way to nicely do this?


ie. Today is 4/29 , the form will default to 5/1 as the suggested Need by date that can be overridden by the user - say they give us 1week instead - 5/6 that should be good.


Genius level 1: Relative +2 calendar days

Genius level 2: Relative +2 weekdays

Genius level 3: if entered date is less than Relative +2 weekdays throw a warning flag at the form user saying ahhh you better be in a bind here. (stern face)

Best Answer

Answers