Date restrictions or drop down automation

Options
Trish Dillon
Trish Dillon ✭✭✭✭✭✭
in Formulas and Functions

Hello All

Is there a way to restrict date fields on a form to only M-F and nonholidays up to a month out? We want them only to select available dates.

I am using a drop-down, and I have to adjust the options each week. This form will have ongoing usage.

Any suggestions on how to do this best or automate it?

Thanks!


Trish Dillon

https://www.linkedin.com/in/trishdillon/

Tags:
· Share on FacebookShare on Twitter

Answers

  • marc4
    marc4 ✭✭✭✭
    Options

    Do you have a place you can run a script that uses the API? You could run a script each Sunday that updates the pulldown for the dates M-F and if you have a list of holidays, it would skips those dates

    /marc

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!