Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

I want to check a box if the outage was identified on a workday between 8:00-16:00

Day of week Notification Date Notification Time(military)

I have separated the time from the date and it is in military time. So I have a notification date and a notification time. I have created a help column to identify the day of the week.

I want to check a box if: the day of the week is greater than 1 and less than 7 and the time is greater than or equal to 8 and less than or equal to16

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions