Working with Date/Time
I am aware smartsheet has some limitations when using Date/Time functions, but would really appreciate any help.
I am working with inputs from a form, where smartsheet is providing the Auto-Number/System Date and Time of a form input. I need to check if the time portion of this cell is before or after 4:00PM to trigger a workflow action. Is there any way I can setup a formula which could result in a "Yes/No" output to be used as a workflow condition?
Also, does smartsheet have any functionality related to Business Days like in Excel?
Help Article Resources
Check out the Formula Handbook template!