-
Issues Opening the Sheets
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
-
Merged: Change Report Column Header Name
This discussion has been merged.
-
Unable to Edit Sheets After License Renewal (Owner Access Issue)
Hi everyone, I’ve been a Smartsheet user for over 3 years. However, after renewing my license in December, I’m no longer able to edit any sheets or projects — even those where I’m clearly listed as the Owner. I have a Business plan, the renewal has already been paid, and this issue started only after the renewal. When I…
-
How do I share a report document to an external client without having to give full access to the doc
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
JOIN-COLLECT and Contact
Hello, I am trying to use JOIN-COLLECT to populate a cell with a contact by pulling from another sheet. However, when I use this formula it populates the cell with the name of the contact as a text string, but does not populate the cell with the contact itself. Both the column of cells being populated and the column the…
-
Why do all sheets now need to be part of a workspace?
I am trying to set a workflow for an existing sheet, I have Admin permission. Once the rows meet a certain criteria I need them moved, one sheet to another. I created the new sheet, to where the rows need to be moved, which makes me the owner. However, when creating the new sheet, it creates a whole new workspace, like…
-
Multiselect Dashboard Widget HELP!
Hello! I am attempting to create a dashboard widget that shows me how much budget we are spending in each segment, and in what category. The source sheet contains these columns… "Budget" - text/number column "Category" - dropdown list (restricted to list values only) "Segment" - dropdown list (allows multiple values per…
-
"Move row" automation option for "origin sheet"
I have a few Smartsheet solutions in place where a sheet is a destination for "Move row" automations from multiple sheets. For example a "Completed" sheet could have rows moved to it from 20 other "Active" sheets (each active sheet having a "Move row" automation to move rows at the end of each day when all checkboxes are…
-
Dynamic View Predetermined Fields
I have a form that is completed by 16 different entities for 57 unique roles, filling a master sheet. I want to utilize the Dynamic View function, but also have prefilled fields and use a MATCH function from the master sheet to the dynamic view to match the input to the unique roles. The purpose is that there are a finite…