Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Separating weekdays from weekends

Michael Ott
edited 12/09/19 in Archived 2016 Posts

Hi everyone,


this is probably something very simple, but I still struggle, hope you can help. 


I have a large timesheet with one raw per day, every day of the year. 


The contractors will get paid higher rates on weekends, compared to work days. Initially I thought of putting an extra checkbox "weekend" column next to the date, but this is a manual solution. 


Is there a way of building a formula that automatically checks if the date column is a workday or a weekend and applies different rates to the dollar calculations?


Thank you!


This discussion has been closed.