-
Azure authentication & process mailboxes
Sysadmin Security question - My understanding is if we use Azure authentication as SSO and auto-provisioning, everyone that logs in to our enterprise account has to be real person with their own email address. We cannot assign a license to a 'process mailbox' that multiple people access. We're in a Microsoft environment…
-
Error pulling in % Complete in metadata for the current project phase.
Hi Community, Hope your week is starting out well. I would appreciate any help you can provide. I am getting Unparseable error in the "Phase % Complete" cell in the Metadata sheet. I'm trying to pull in the "% Complete" from the Project Plan for the "Current Phase", which is "Onboarding". As you can see, I have the…
-
Formula to list department name when individuals name is listed in another column
Hello! Formula help for the following scenarios: Scenario 1: When Jess Baker is selected in "stakeholder lead" column (multi select enabled), the "department" column automatically populates to "MEQA" Scenario 2: When Dan Striker is selected in "stakeholder lead" column (multi select enabled), the "department" column…
-
User Inconvenience regarding label navigation bar
Hi, We are using so many sub-labels in Brandfolder, so we have almost 900 labels in total. But when we click lots of labels to look for some assets, leave Brandfolder, and get back to Brandfolder later, the label navigation bar are being kept unfolded as the way we clicked them, which is very unconvenient. Is there any way…
-
Import Data Elements into Resource Management
Please allow for import of holidays, Place Holders, Disciplines, Roles, Locations and custom fields into resource management. Basically all fields that do not already have an import/export. It takes too long to key these things. Also if I set holidays and the values in smartsheet this should have synced up upon import.
-
Linking new entries to previous entries - tracking attendance
I'm trying to create an easier/faster way to track attendance at the multi-week classes that our health educators teach. Currently, they have to enter in static information every time they complete our outreach tool (like, address, timing etc) and I am trying to make it so that they only have to enter that information one…
-
Formula to sum Children if a Helper Column for Parent Row is checked
I've created a Helper Column that checks itself if it is a Parent Row. I'd like to create a column formula that will automatically sum any children under that Parent Row. Thanks in advance!
-
NETWORKDAYS - extra day calc adjustment
Hi all! I am trying to reflect the actual number of working days between two dates. The NETWORKDAYS function includes the start and end dates in the formula, which adds an extra day, regardless of whether or not any of these dates are working/non-working days. For instance – this formula returns 1 day for the number of…
-
Need formula & function for the question below
If I apply for PTO, I want to make sure it's getting subtracted from the "WR Balance Before Application" and it would be straight subtraction selecting cells & it's sorted. The main formula I am looking for is, If I apply again, my "WR Balance Before Application" should be the latest "WR Balance Left After Application"…
-
Send From Triggering User - not working
Hi, I have an automation set to "send from triggering user" for when any cell is added / changed that links to a sheet . I am the sheet owner . If a person called John Doe fills in the mentioned form from his logged in Smartsheet account , theoretically the automation should kick in, send out and notification email to the…