Date Field/Column - Weekdays Only

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?


  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    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.



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