-
Linking Text Boxes in a Dashboard to a Sheet.
A co-worker of mine is trying to link the text boxes in a dashboard to other sheets. I know its possible to link to the words in the text box, yet you cannot link to the title of the box. So I'm curious if there's a work around for the title link or if you can make the textbox itself a link? Thank You, Hunter G.
-
Count Ifs AND
Im trying to do a count that captures criteria where both the Status is makred as closed and the TEA Jurisdiction is marked as yes. =COUNTIF(AND([Status]:[Status], "Closed", [TEA Jurisdiction]:[TEA Jurisdiction], "yes")) I keep getting the incorrect argument set error. Thanks for any help
-
Gantt VIew in Dashboard
I'm trying to show Portfolio level timeline - so I've created a report and in that report I have start date/end dates and desired start date for the projects in the pipeline. However my Gantt view does not include the full timeline from start to end. It is just showing the Start Date - I would like to show the entire…
-
Portal Shortcut to a Template I've Created?
I have created a template to use in opening customer based Sheets. I would like to add a shortcut to that template on my Portal. The template doesn't appear as a Smartsheet item (like other sheets, for instance), nor does it appear to have an associated URL (like forms). How can I add a shortcut?
-
Why doesn't the Multi Select Drodown work properly?
I selected the multi select dropdown option and it allowed me to enter multiple values in one column, and then few minutes later, when I left click on the list's arrow, it wouldn't work at all, and it would only allow me to enter one value if I change the settings to the single select option. Did anyone experience this…
-
Auto Refresh for embedded Google spreadsheet in Smartsheet Dashboard
Hi, I embedded a Google spreadsheet in my smartsheet dashboard. I set the functionality in the google sheet to publish immediately after it's updated. Will this reflect in Smartsheet without me having to embed a new link each time?
-
When a new row is added to a sheet, can perimeters be set for it to automatically sort?
When a new row is added to a sheet, can perimeters be set for it to automatically sort its row location based on column info(ie. date, detailer, job). Basically how the "sort rows" function works, but automatically.
-
Copy Row Issue
Just had an issue where my copy to workflow only worked on 2 rows out of ~15. This is not a new workflow, and has been tested and functional over 30 times, and no one has accessed or changed anything in the sheet other than me. Is anyone else having any issues with this? I really need the workflow to be trustworthy for…
-
Dependent forms
Can you create a dependent form that links part of the form based on what you select on the original form? Form 1 -Type of request Drop down list= New (form2), Product (form3), Equipment (form4), Drug (form5) ~~~~~~~~~~ Form 2 = New service *detail 1, detail 2 detail 3 Form 3=Product *detail 1, detail 2 detail 3 Form 4…
-
Line Graph for Team Member's % Capacity over Time
This discussion was created from comments split from: Line chart with multiple date-numbers traces.
