Sign in to join the conversation:
I'm trying to calculate the number of working days between two date columns in Smartsheet, but I want to exclude weekends from the count. Is there a specific formula or workaround that I can use to achieve this?
You'll want to use this function in your formula:
NETWORKDAYS Function | Smartsheet Learning Center
how to get the formula to get the weighted average of the scrap
I want to set up Smartsheet so that if a request is submitted on the same day and the submission time is between 6:00 PM and 12:00 AM, the Request Submitted Date should automatically move to the next day. For all other cases, it should remain the same day.
I have a column titled "start date" for each of my employees. I would like a reminder sent to a manager at the 30-day mark after their hire date.
