Sign in to join the conversation:
Is there such a thing as a formula for WORKDAY for today? I.e. modifier is 0 instead of + or -
I'd like a field that can go off another field or (work on itself) that can adjust itself to the closest workday, for example.
=WORKDAY([Due in PROD]1, 0)
Try something along the lines of...
=WORKDAY(IF(ISDATE([Due in PROD]1), [Due in PROD]1, TODAY()))
Basically the IF portion will input whatever date is in the [Due in PROD] column. If there is no date, then it will input TODAY(). It will then run the WORKDAY function based off of that result.
Hello, I'm trying to not spam the people I need info from. I have 600 courses and need the course owners to fill in some info for me. Some people are the contact for 30 courses. If I just send an automated request for an update, they'll get 30 emails. Can I automate an email so that each contact just gets one request if…
I use Smartsheet for our audit process. It has worked wonderfully all year but a new set of audits just came in and for whatever reason my team has lost the ability to check the completed check box in the sheet. I have checked to make sure the column is not locked, upgraded their permissions to admin. No luck. Screenshot…
hi, When customizing dashboards, I notice that there are more options available to choose or create color combinations compared to the static color palette that appears in sheets. Do you know how I can include more colors in sheets, similar to what is available in dashboards?
