We are using one sheet with different forms based off of that one sheet. When setting up automation we would want each form to be copied to a diff email address. Need help in setting up that automation properly
force the choice in a % column to a couple of value
Hi, a have a column "%" i would like to force the possible value to "0%" or "100%" during the inser Is it possible? Umberto
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…
Bulk Deleting all outstanding update requests
Hello, I have a few hundred update request on a Smartsheet that simply need to be deleted out. I can go one-by-one and delete these out, but I was hoping there was a way to bulk delete them out. Is there a way to do this?
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?