-
How can I create a 19page Smartsheet form?
I have a 19page form with 38 base questions that to trigger upto 152 additional questions per base question based on No/Yes logic. Smartsheet has a column limit of 200 columns, any ideas on how to string it together so that the survey continuation is triggers.
-
"New Employee Onboarding Template" Question
Hello, I am attempting to modify the "New Employee Onboarding Template" for our team's use. I have two questions. 1) Is it possible to have multiple employees on the same form? Example, Gabriel Hernandez and Joe Random on the same link? Either via checkbox, conditional formatting, etc. Our hope is to not "Save As New" each…
-
build report off of filtered sheet
-
Link project progress with master file
Hi, I have a doubt about cells linking, probably for many of you this will be simple but to me… it's another story. I've created a project's master sheet in a workspace in Smartsheet which we use to manage new projects, an online form feeds this file. Each time a new project is created, we assign it a unique ID. After the…
-
Alert Someone Workflow Not Working
I created a sheet with an automation that alerts someone (names I hardwired into the automation) at a specific date and time. No condition rules. For some reason, it does not work at all. Even when I try to have the notification sent to myself, it does not work. I have duplicated the workflow and even tried to copy the…
-
Workflow-generated PDF bleeds into adjacent areas
Hello! I am having trouble with a fillable PDF that is being filled/generated using a workflow, stemming from a form submission. Sometimes, the data captured on the submission form is lengthy. Because of this, the fields in the fillable PDF I mapped are set to multi-line + scrollable. Otherwise, they would be huge. When…
-
How can I return my project sheet to a version before the changes were made by mistake?
I need to return changes made by mistake to a sheet. By mistake, when editing my Project Settings, the dates recorded for my project were changed to the dates of other columns. I need to recover the dates that I registered for. How can I return my project sheet to a version before the changes were made by mistake?I know…
-
How can I get the legend for a pie chart to display ALL series even when their current value is 0?
I've been having this issue while building dashboards for a while. I want to use a pie chart, the data contains 4 series. The values will update via their formulas over time, but right now the value for 3 of the 4 series is 0. For all of the other types of graphs, all series are displayed in the legend regardless of their…
-
Graph with columns and lines
Hi everyone - I hope that everybody is fine out there. I am asked to produce graphs with a blend of stacked columns and unstacked columns. Here are the 3 pieces of information that I need to graph: 1) Cumulative monthly targets 2) Actual monthly completes stacked on top of monthly Planned to be completed So far, I can only…
-
Auto Numbering
Hello, On my automatic numbering, it went from DCR036 to DCR051 and I have no Idea why. Well I tried to reset it but every time I redo it, delete column, save, add new column, save start from DCR001, save...it keeps increasing instead of starting from 1 again. How do I have it to start from DCR001 again, starting from Row…
