-
Manage Azure AD users in Smartsheet
Hi, Currently we have a Business Plan Suite, is there a way to manage our Azure AD users in Smartsheet? For example, We have our personal info filled in in Azure AD, how can I import this into Smartsheet? Thanks in advance.
-
Dynamic View: Give access for requestors via their email address
Hi Community, we are using Status View at the moment to share the actual status of IT requests (Demands) to the requestors of different department. The access is given to the requestor via their email address they have to maintain while handing in the request and then they have to login in to status view with this email…
-
How Nested IF can I get?
I have a desire to change a Status column based on whether (or not) certain separate (other) columns are populated with a date. Is this supposed to work? All of the Nested IF examples I have seen tend to look at just a single column to evaluate against, and I'm wondering if I'm going to be able to make this work, and using…
-
Automated Workflow - Invalid Date Error
I have set up an automated workflow to trigger when status changes to complete if date field is greater than 12/31/18. I am able to choose the date but it changes to "Invalid date" when i save the workflow. I thought maybe since the date field i was using is an automatic number field, it didn't recognize the field as a…
-
Linked Cell Format Issue
Hello everyone, I have tried looking for this topic, however, I can't seem to find anything. I have a source sheet with dollar amounts and the cells include a number such as $100,000.00. When I link the cell to a new sheet, the number shows up as 100000 Any idea how to fix this? Thank you. Sincerely, Diego
-
FILTER
Hi, Please can someone suggest an dynamic alternative for Smartsheet to the FILTER function that Google Sheets have to include in a report. I have a list of Asset I.D's that have multiple statuses at any given time. I would like to capture each Asset I.D assigned to each person according to the Asset's status. ie: all…
-
Cross sheet Formula to pull in column value
Hello, I have a Master Server Inventory sheet with columns such as Server Type, Server Name, Recovery Method, and several other columns with common data that has to be collected for all servers. I need to create a variety of separate sheets with detailed configuration data about each server. I want to reference and pull…
-
Metric Sheet Calculations for a Dashboard
Evening All, i'm looking to see how I can add to this formula a rule to not include sales variances of 100%. This shows when I am comparing year over year sales and the site does not have those figures to compare. =IFERROR(AVG({Sales Variance}), "") Many thanks, Sarah
-
Jira Connected Sheet and Hierarchy re-arrangement
Hi- I have been doing some searching on the community and cannot find a clear reason or explanation as to how to to set up the "Optional: Define Row Groups" I cannot find any documentation or help videos on YouTube or the community that explains how this works. Here is a screenshot of my sample project Here is what each…
-
Capture date when row changes
Hi, I have a status column in my row that changes from "animating" to "approved" and would like the start and end date columns to update when status is changed. ie: 1. When status column changes to "animating" - start date needs to capture the date(fixed value) it was changed to "animating" 2. When status column changes to…