I have a formula that works in excel but want to convert to smartsheet, can anyone help?

Sarah Jane Mitchell

We are trying to create a collaborative tracker that will be used by multiple countries and want to avoid emailing the tracker, so I suggested smartsheet but coming up against formulas, can anyone support or point me in the right direction.

=WORKDAY.INTL($B7,C$3,7,0)-1

GrahamWelsby

Hello, if I've understood this correctly, your trying to work out Weekday's between two dates without weekends?

If so, try using Networkdays for smartsheet formula?

https://help.smartsheet.com/function/networkdays

I've used this and seems to work out OK.

Thanks

Graham

Sarah Jane Mitchell

Thanks Graham, I’ll give it a go.