Date Field/Column - Weekdays Only

Options
Bryenne Albright
edited 01/27/21 in Smartsheet Basics

Is there a formula to use that formats the Date Field/Column to not allow weekdays to be chosen when added to a form?

Is there also a formula that would only show dates starting 4 weeks out from current date?

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    Hi @Bryenne Albright ,

    You can't validate form entries while the form is being completed. You can use an automation rule to request an update if the submitter enters an erroneous value, e.g. a weekend date when only weekdays are expected or a date within a 4 week window.

    Nor is it possible to restrict date input to a date 4 weeks out. You can add an update automation, as above.

    To confirm a date is 4 weeks out you could use something along the lines of:

    If(Week([date submitted]@row)<week(today())+4, "error", "valid")

    IF([date submitted]@row<Today(28), "error", "valid")

    In your automation logic, if the check value was "error" it would trigger the update request.

    Help?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.