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
I have a report that will generally only have about 15 rows on it. I see in other threads that Smartsheet will automatically create enough blank rows to reach 50, or at least 10 blank rows always at the bottom. Even if I delete the blank rows from the Sheet (which has hundreds of data rows), they reappear the next time I…
I need to setup automations based on a contract date that will notify me on a monthly/quarterly/annual basis so I can process paperwork at the appropriate time. Ideally, I'd like to set it up to send an email 90 days before that date. I have columns for the initial contract date and the frequency (one for the word…
Hi everyone, Is there a way to set a dashboard as the default homepage for all users upon login? Ideally, we’d like users to land directly on a particular dashboard instead of the usual default page. Is this possible through configuration, or is there a plugin or workaround that can help us achieve this? Thanks in advance!
