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 she…
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…
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…
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 ba…
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 w…
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…
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 t…
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 "curr…