Sign in to join the conversation:
Hello,
I am trying to set conditional formatting to highlight due date cells when it is within 3 working days, however the sheet counts Saturday and Sunday as days.
Is there anyway of setting the sheet so saturday & sunday do not count as days?
You may need to use a WORKDAY or NETWORKDAYS formula somewhere. You could put it in a hidden column or use it to drive a RYG column and base your conditional formatting off of that.
Thanks very much. I will look at this on Monday, have a great weekend.
Thanks again
This discussion was created from comments split from: How can I send an attachment from a line with an automation workflow to a recipient?.
My Smartsheet is generating a document with weird text, see below. This issue happens in both Microsoft edge and google chrome. Can anyone advise?
Hi Smartsheet, What's the current max-cell-count for grid view? Is there an easy way to identify where the sheet is at for cell count? I've asked AI a few times, ways. It's a little confused today. Also did a few count( formulas, but Excel seemed to produce a better assessment. 🤨 Thx, Eric
