-
Removing Rows at Bottom of Sheet - Affecting Formulas on Dashboard
There are about 10 blank rows at the bottom of my sheet that keep coming back, even after I delete them. I either need to know how to permanently delete them or how to adjust my formulas to not include them because they are affecting our dashboard results. Any help or advice anyone has is welcome. Thank you!
-
Docusign Integration - Attach final Envelope as separate docs?
We are using a Template Docusign Envelope (with multiple documents in the envelope) and sending that via Smartsheet Generate Docs Docusign Integration. When the doc envelope is complete, the document attaches as one combined PDF in Smartsheet. Anyone know if there is a way to have these attach in Smartsheet as separate…
-
Large criterion name
Hello, I'm trying to make a formula to count the number of jobs by builder for the month of January to go into my sheet summary. I managed to get the formula working for January however when i copied and pasted the formula and changed the name of the builder i got #invalid operation. The working formula is as follows,…
-
How to edit a workspace
I have been given "Editor-cannot share" permissions by the owner of a workspace but I am unable to make any edits in the shared workspace. When I try to double click on an empty cell, I do not get to edit it. Please advise.
-
Combine values in column only if value in each row is less than a value
I have a column with an identifier in each row and in another column I have a value in each row. I want to search the second row for any values that are less than a reference cell, and if less that that reference cell, I want the text from the first column to be displayed in the cell the formula is in separated by , if…
-
Meeting Recording
Hello Admins, I attended session on "Intro to WorkApps" occurred on December 08 2021. Can anyone send the session recording video?
-
Graphs from Excel into Smartsheet
Is there a way to take a graph that was created in Excel and import it into a Smartsheet? I can do it via a dashboard but I would like to have it directly on the sheet with the data.
-
Why can't Smartsheet work in an Ipad Browser?
I understand there is an IOS app but it does not come close to the computer browser based environment, it doesn't perform as well, doesn't have matching capability, heck even the user interface is different. I do not care for the app but I love Smartsheet in a computer browser. I am baffled as to why Smartsheet does not…
-
Copy and move row workflow disabled by smartsheet
My copy/move row workflows (that previously worked) were disabled yesterday. I now have an error that says "Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet." Anyone else have this issue? If this is new functionality, then the workflow will only work…
-
Editable Report with Shared Sheet that's Hidden/Locked
Is there a way to make the report editable by the user with a sheet that is shared to them as "Editor - cannot share", but making it to where they can't alter the actual properties of the sheet itself? Thanks in advance!