-
Dashboard Template Chart Works - Mine Doesn't with Same Config
I found a dashboard chart on a SmartSheet template that I'm trying to duplicate. I've verified the data in the chart is the same between "My Chart" and the "Template Chart". I've verified the chart config is the same. What the chart shows is different and doesn't seem to reflect my data accurately. What am I missing?
-
Drop Down Columns
Is there something on the Smartsheet Roadmap to be able to select multiple items from a Drop Down column in the similar way we can select multiple contacts in a Contact List column?
-
SSIS package to read Smartsheet data to export the data into SQL database
I need to bring data from Smart sheet data into sql server using ssis. can anyone suggest the steps.
-
Hyperlink from a report
I have a report from a smart sheet. I want to have a hyperlink to be able to open the data sheet from the report, but the data sheet is not listed as a sheet when you open the hyperlink to another sheet. Why can I not see it?
-
Auto Assign a Predecessor in Gantt
Hi, I have a series of standard processes that have the same dependency and predecessor data each time. I have the primary column as a job number, and then a second column with a drop down list of all the standard processes (I.e. assembly, pre-assembly etc.). If pre-assembly is selected, for example, I always want it to…
-
COUNTIF, ISBLANK, and OR formula
For a particular project category, I'm attempting to count how many times the "Project Status" column is either a blank cell or not "green" (aka complete). These projects will be marked as "Active" on my stats sheet. Here's the formula that I have thus far and I'm receiving an Invalid Operation error: =COUNTIFS({CDVL…
-
Custom Welcome Screen not rendering properly
I have a dashboard with a lot of content that I wanted to set as the default welcome page. When I enable custom content and enter the dashboard URL I can see it in the preview, however when logging back into the system instead of the preview of the dashboard I get 3 windows rendered on top of each other. Each one is…
-
Is Smartsheet down?
I'm attempting to do some work in Smartsheet and the site doesn't allow me to connect. Is anyone else having this issue?? This is especially concerning becasue I have a presentation/demo to show how were using this platform. Please advise.
-
Duplicates, can I count the Original but ignore 2nd, 3rd etc
Hi I had a look but couldn't find the answer. I am trying to do simple reports and formula Counts, but trying to ignore any duplicates. Example below, I am only interested in counting the first time a name appears, so the count would equal 5 Names, ignoring where there is a second or third. Names Andrew Dave Phil Sarah…
-
Customer Database
I'm looking for a way to track our applicant demographics. Any one have any ideas to track all your customers in one place?