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

Options
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!

Comments

This discussion has been closed.