-
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?
-
How to get the sum only for a Specific Dropdown Value Selected
Hi, I want to get the sum for only the dropdown value selected: Here is the Situation: First Column: I have 3 Resource Type: 1. Offshore 2. Onshore 3. Remote Column 2: I have resource Name Column 03 to 35 is a Hour Cloumn ( Where it shows how mnay hours each of my resource is available to work) Now I need to calculate: 1.…
-
Copying names into contact columns doesn't assign
We have about 500 rows in a sheet that need to be assigned daily. A team member will mass copy names from Excel into the contact column of our Smartsheet sheet. I would like to use the filter by "current user" functionality but, when pasting names in, the contact column does not pick up that the names are actual contacts.…
-
C# SDK - A strongly-named assembly is required
Edit - I started from scratch rebuilding it, and that solved whatever bug was causing the issue. I still have no idea what was wrong. I'm using Visual studio/C# to make a dll for Office/VBA automation. This was working until the TLS 1.0 deprecation on 3/31. I updated the SDK to to the newest version using the NuGet manager…