-
Contact Cell Automation - Multiple Criteria
Hi, I have a list of criteria in a column and I want to automate a contact to one person if certain criteria is selected and another person if other criteria is selected. However, the intake form allows for both sets of criteria to be selected on the same line. Is it possible to build the automation to alert both parties…
-
Report not sorting properly after adding the year
Hello, Help. My report, which is sorted alpahbetically, was exactly how we needed it to appear until I had to add "2023" before each sheet name and now it seems it has a mind of it's own. "2023 Call Center..." should come before "2023 COBRA...." and "2023 SA Out of scope.." moved it's way up in the list. I have removed…
-
How do I create a "Network Diagram"
Hi - Can anyone explain how they have created a "Network Diagram" (example) from a Smartsheet project plan data? I realize that it is not possible to automatically create these within Smartsheet, but I was wondering if anyone has done this by exporting their project data to a tool like Lucid or other software. Thanks, Marc
-
Gantt view not showing critical path in red
I recall this may be an issue with indentation but can't find the information now. I would like to use my sheet as both a master task tracker and a section for schedule. When I click on the critical path icon in gantt view I don't see the content highlighted in red. Dependencies are set and such already.
-
duration not adding correctly
I have a smartsheet that isn't adding the duration correctly. I have a 7day task starting 11/15, so this should end on 11/22. On a coworker's smartsheet this task is 7d, starts on 11/15 and ends on the 11/22, as expected. If I make this task 0 days, it ends on 11/15, and if I make it 1 day, it also ends on 11/15, which is…
-
Predict or set which row a form writes to
I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the Sheet. I am using an Index/Match to go to the row data that I need to pull from the forms responses, and that works great. Here's the issue: When a…
-
Is there a way to format groups in a report?
I have created a report that pulls every task with my name on it, and they're grouped by sheet name. Is it possible to change the group header where I can add notes, change cell color etc? If not, is there a way I can create a new sheet that pulls the same tasks?
-
Is anyone else getting this message
I repeatedly keep getting this message "sorry we're having trouble reaching smartsheet right now. Please check for any known issues at status.smartsheet.com or contact us at www.smartsheet.com/gethelp for help.". It happens on different sheets and doing different processes so I can't pin point it to one thing. I am not…
-
How can I view the total list of specific fields from the dropdown.
Currently, the dropdown appears to be limited and does indicate the number of fields that are not being displayed. How can I expand the view to see all of the specific fields. See screenshot.
-
Chart Widget shortcut to Filtered Sheet
Dashboards charts tend to reference a subset of a sheet. It's logical to want to drill down to that specific data subset when trying to find more information on a graphic. Is there a way to make widget behavior->open data source also apply a pre existing sheet filter?