-
Excluding a certain value
I have a sumifs formula right now and I'm trying to get it so that if I have a certain value in the cost code column even though the two criterion match, it wont count it because the code that is in that row is one I don't want count. I've seen other people have similar problems and this is what I thought could work but it…
-
Count / Distinct - Total of unique values based on logic.
Hi, I have a sheet that holds vendor and contract information. Each vendor can have multiple contracts (rows). 3 of the columns are "Vendor" and "Contract Status" and "Contract Type". I have a separate metric sheet. In the metric sheet, using ranges, I want to be able to show: The number of unique / distinct vendors. I can…
-
Contact List For Approval Workflow
Hi all, this might be a simple question, however I'm a little stumped. When creating a workflow and choosing "Send to specific people", where is Smartsheet pulling the options for a name to choose? In my screenshot, it is showing individuals with their name & email address and some with just email address? We have a column…
-
Workflow not showing all dropdown options
I have a simple workflow that changes the value in some cells when "business Critical? is not set to no but for some reason not all the values in the dropdown show up the last one just isn't there and when i try and copy that last option into the workflow it just doesn't recognize it and works the same as if its not there…
-
How to use Scatterplot so it shows dots based on X Y values and displays label at the dot?
Hi, So, I have been trying to figure out how to use the scatterplot function in dashboarding. But I'm not able to make it work. I want to plot project names based on their Impact versus Effort (both scored 0 to 10) and add the project names right next to the dot. I can make it work in Excel, but can't find a way to make it…
-
Best Practices Email for Smartsheets
I want to send out an email to my team including smartsheets Best Practices for sheet setup, security on sheet level, keeping our workspace as secure as possible, Setup best practices regarding sheet, dashboards, dynamic views, etc...
-
Sheets with Open Access
Is there any way from the admin panel to find out which sheets have open access? Meaning, which sheets in the organization allow anyone to view them or have outside email addresses that can edit them?
-
Why as the sheet owner am I only able to view my own sheet on the mobile app?
I created a sheet on my PC and can access it on my personal phone (Android), but when I attempt to access it from a company device (Android phone), it is view only. This is significant because we are rolling out a system that uses Smartsheet on handheld devices, but if it is view only, it is worthless. See the images…
-
Enhancement Request: Sheet Name on Update Requests
I've searched and haven't seen this topic posted yet. Our company has hundreds of individual projects running simultaneously, so when I send an update request to an individual there is no indication which project the request is referring to. I realize that I could add a column that is populated with only the project name,…
-
Sharing New Template on Dashboard
We have created several templates that live in folders because they have sheet/report/dashboard tied to them. I would like to share these templates on a dashboard so someone simply clicks on the template and are asked to save the template folder to a new workspace. I haven't figured out a way to do this. Anyone have any…