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.
I have inly one user in my trial account. When I am trying to upgrade to PRO plan it is defaulting for 2 users and not allowing me to upgrade the plan for only one user. Please help.
We are curious if anyone is experiencing issues with automations that are to generate emails. We've been seeing gaps with a number of these automation on various sheets, where the sheet will record a date of when the email was sent, but it is either never received by the recipients or it is received hours or a day later.…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
