-
Access Requests
Morning All, we have a lot of staff requesting access to various sheets, I am looking for ideas on how to maintain this - keep track of it - when someone requests access having the sheet owner or manager of that department approve the access and the level of access Any ideas :-)
-
Sharing dashboard link without adding the individual as a user
Hi all, is there a way to share a dashboard with someone without adding them as a user? The only way to share a dashboard is via the share link, then to add the user following the steps below:
-
Recommendation question on Automation setups
I'm working on some simple automations and revisiting some other ones that were built before I was using smartsheet and wanted to get an opinion on best practices. When setting up automation with condition path's, do you recommend multiple automations or 1 with multiple conditions. For example, I've got a field called…
-
Country flag shows wrong in form when using Validation
When I select Canada as the country for phone number validation in the form creator, it shows the American flag on the Form. It's great you're patriotic but an your neighbour to the North have a little piece of the pie?
-
Change Gantt Color Automatically for Sheet and Report
Hello @Genevieve P.! Overall, I'm attempting to create a report that shows multiple different projects. In that report, I will be able to see each projects' gantt bars. I'd like to color code the gantt bars to represent different phases in the projects in order to see what phase each project is in during a certain time…
-
Send email to a person in a column/cell when a cell status changes?
When someone changes a cell to a certain dropdown option in Column 1, I would like it to send an email alert to the person listed in Column 2. Is this possible?
-
What's best practice for managing multiple variations for a date?
I'm working on a sheet where we need to capture several variations for each of 3 date columns (e.g., Drafted Date, Reviewed Date, Approved Date, etc.). For each of those dates, I need to capture the baseline, best case, worst case, current estimate, and actual. As you can imagine, it's a bit unwieldy visually and a little…
-
Adding a New Card in Card View Auto Adds to Uncategorized
Hello! In my sheet, I have the card view setup to view by my "Parent" column which is a dropdown column type with a column formula that pulls the Parent task name of my row, because that's what I need my columns to be. When I'm in the card view, and I click the "+" icon in my lane to add a new task, I enter the name and…
-
Is there a way to automatically update an excel file from smartsheet
I am trying to display turn around time but we have so much data and the smartsheet charts aren't advanced enough to show what we need. I would like to use excel to graph the data but the smartsheet is updated daily and manually exporting to excel would be such a hassle. Is there any way I can make it export the data from…
-
why doesn't Smartsheet save???
Others have asked the same question, but it still never gets answered by Smartsheet. How am I certain to login and be sure that my work is saved after clicking the save icon and/or Ctrl+S? This is a real problem that everyone should be aware of and understand how to resolve. It is not productive to waste hours of time only…
