Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
=DATEONLY VARIANCE COUNTING WEEKDENDS
Hi,
Trying to use the =dateonly to get the variance between planned start and actual start, but it looks like the calculation is counting the weekend days when in only want it to count weekdays. Is this possible?
Comments
-
The networkday function should help with this use case. You can read more about this and our other functions here.
-
I think that is working, thanks so much!
