-
How do I take information from two sheets and auto populate into a third sheet?
I am trying to set up this smart sheet where it has a entity that someone can select from a drop down menu. Once they clicked any entity I had it V lookup from another sheet and it would auto generate the address for that entity from a different sheet into the cell next to it. I figured out how to do this part. I am…
-
List of workspaces, sheet, dashboard, report with its owner information
Is there a way to get a list of workspaces, sheet, dashboard, report with its owner information? How to manage all the item in an account? Thanks in advance
-
Baselines
Hi there, I have a query that I'm hoping someone will be able to help with - when adding a new activity to a project plan how do I ensure that the variance is tracked without resetting the baselines for the whole project? I am finding that if I add a new activity its baseline start and finish are not automatically…
-
API Service Account Login
I am extensively using the API to create actions and generate data in sheets and the source of that data always shows up as my user, I would either like the option to make that show up as the smartsheet automation user or as a service account so the ability to generate a username and an API key under my account that will…
-
What is the Cloud storage size of Enterprise Plan.
I'd like to know what is our cloud storage size for an Enterprise Plan, per user and per organization or group. Thanks!
-
Approved Domain Sharing
Hi all, As an Admin I would like to run a report to establish what external users have been given access to our content. All external users have to be in the approved domain sharing list, however what are they accessing? Thanks Gavin
-
Hello from Jo based in Australia
Hi everyone - Looking forward to becoming an active member of this community. My career is in MedTech and new business startups, specifically in Sales Leadership/Management and Business Development. Introduced to Smartsheet 18 months and am keen to transition into PM. Looking forward to learning more and would appreciate…
-
Assigned To shows email address not name
When I setup the contact in My Smartsheet Contacts I include the "Name" and "email address", yet when I go to assign the person to the "Assigned To" column sometimes it only shows the email address and not the name. We have a small team and I just want to see "Mary" in my "Assigned To", not "Mary.Jones@abc.com"
-
IF Cell Contains This Text VLOOKUP
Hello, The Status Column has a dropdown menu with multiple options with the text "Completed" and some other options: Completed awaiting Signature Completed Reviewing Completed Approved Failed Inspection I want this formula to work with any options from the drop-down menu with the letter completed. This is what I have so…