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.
This discussion was created from comments split from: Plan Asset Manager - will it capture orphaned assets already in the system?.
In the new USM, are users who are designated as Viewers only able to download/export sheets they are given access to e.g. to Excel?
I just tried to create my first dashboard using the timeline chart widget. I have set it to open the source data when clicked however it does not work. I've done this multiple times without success. It seems this is not actually an option even though you can select it in the settings. Can someone verify this or is there…
