-
Inconsistency with copy row automation
Hello! I am running into some issues when attempting to utilize a copy row automation. Sometimes the rows are copied to another sheet, and sometimes they're not. Here's a breakdown of my process... Sheet 1- approval workflow is automated upon form submission, records a date when approval is granted Sheet 2- utilizes a…
-
How to remove no longer used lanes in Card View?
My sheet has named people in the contact list (the column card view is sorted by) who are no longer allocated any projects on this particular sheet but they still have a lane showing with (0) next to their name. I can collapse the lane but it means I have a lot of collapsed lanes cluttering the sheet. How do I get rid of…
-
Generating values that can be referenced in a drop-down
Hi, I'm looking to create a formula and cell reference system that can be used to generate a value that can be referenced in another cell or ideally a form. Here's the workflow breakdown. The field fills out a form that creates a new line with an auto-generated "Request Number" If the form has a "Build" in the "Request…
-
Using a master sheet to change multiple sheets
Currently, I have a project template that I use for opening a new location. Our company is typically working on 5 or more location opening projects at a time. When changes need to be made to the basic structure of the project plan (i.e. deleting a task, adding a task, adding a column etc.) this change has to be made across…
-
Calendar view on dashboard
Is there a way to set the default view of a sheet/report on a dashboard to calendar? (I don't have the Calendar App.)
-
Feature request: ability to edit and link to sheet cells from a Dashboard
Hi! Following up on this feature request, we would also like to request the ability to edit cells from a Dashboard and well as linking to them. Our use case is simple: our team uses dashboards for individual task and team management, and the ability to do quick edits and link to that specific row from a Dashboard would…
-
Automatic creation of sheets
Hi, I'm wondering if there is a way to automatically create a tracker from a template when a row is added to a master sheet? So, I'd have a form add rows to a master sheet, then I'd like that to automatically start an individual tracker that I've setup as a template. And can those trackers be automatically saved in another…
-
Formstack pdf returned to Smartsheet
Our current setup is Smartsheet information to Zapier to Formstack which emails the pdf to us. I would like to have the form sent back to Smartsheet, to cut out the email, & according to Formstack (Overview tab) it is completing this process however the form does not appear in my Smartsheet and I do not find that it has…
-
IFERROR Formula
Hi All, Hope you're keeping well. I've recently started playing with IFERROR's and updating some existing sheets. I have a sheet that reports with each row being a week of the year. Many of the formulas for "Rows in the future" or in some case, "Rows in the Past" return DIV0 or similar errors which I'm trying to eliminate.…
-
Cursor Bug when Referencing other Sheets in a Formula
Hi, I found a bug when referencing other sheets in a formula. When referencing multiple ranges from other sheets, the cursor will go outside of the braces for the first reference, then will go inside the braces for every reference after. I need to either click outside of the braces or hit the right key to get outside of…