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
everytime I try to open the app on my phone it just says loading and spins and spins and then a message pops up that says “this is taking longer than expected.” I have only been able to successfully open the app once in the last 3 months and that was the first time I used it. Anyone else struggling with this or have…
I do not use Smartsheet but am the admin for a company that uses it daily. We had a former employee cancel our company plan when the annual invoice inadvertently charged his credit card. We have since reinstated the plan; however, my colleagues are unable to access, edit, view or otherwise do anything with their data and…
Hello, I've been a Smartsheet user for many years and just this week, Smartsheet is indicated that "your sheet is read only until a paid upgrade". I renewed this past January on a yearly PRO plan. I've tried opening in 'incognito mode' and logging in which resolved the issue one time only. Has anyone experienced this and…
