-
What view are you? Share your story and claim your badge
Hello Smartsheet Community, We love reading stories about the meaningful change you’re driving at work. Everyone has their own way of managing work, right? That's why we've ensured you always have a Smartsheet view that fits your needs. We want to hear how you are using Smartsheet and how it may change depending on the…
-
Help with a cross sheet formula: counting unique values when certain parameters are met
Hi there - I'm in need of a little help with a formula for a metrics sheet I'm creating. Metrics sheet looks like this: And I'd like the Units cell to display the a count of how many times a ID Number shows up in another sheet for the month and the year. In this case, the result for Jan 2025 would be 7 (since EQN187742 is…
-
Importing excel with a column containing Hyperlinks into Smartsheet
I have an excel that contains values that are hyperlinks constructed with Hyperlink construct. for eg: =HYPERLINK("https://docs.oracle.com/en/cloud/saas/readiness/common/26b/common26b/26B-common-wn-f43843.htm","Multifactor Authentication (MFA)") When I import that into smartsheet, all the values read #UNPARSEABLE. I see…
-
Reports - Sorting & Grouping
Who can sort a report and group a report? I have a report that I made another member admin on - however they are unable to change the filters or group and ungroup Do they need to be admin to the underlying sheet?
-
"File Didn't Attach. Try again"
When I try attaching files to lines on Smartsheet, I'm getting the error message "File didn't attach. Try again." Does anyone know of a solution?
-
Renaming a column in our intake form that links to the metadata via Control Centre
Hi, Last week I added a new column to our intake sheet and used the Global updates to link this column into the Metadata sheet for each of my (almost 1000) provisioned projects. I realized that I made a typo in the column name that I'd like to correct. However, before I go screwing with this, I'd love it if someone could…
-
Dynamic View: Change Source Sheet
I have a number of relatively complexly configured dynamic views (help text, display logic, etc.), and I need to preserve all of those features for each of the configurations (which I can accomplish via a save as new), but I also need change the source sheet. It would be nice to be able to change the source sheet for a…
-
Board View Report Without Giving Users Access to Sheet
We have a Smartsheet form where users can request a certificate of insurance. Their email address is recorded in a contact field. I've created a report that filters the contact field to the current user. We'd like for them to be able to see the report in board view, but only for their requests, and do not want to give them…
-
Decouple Comment Lock From Row Lock
I would like to be able to lock a row (and thus prevent editing it's content) WITHOUT locking the ability to add, update, edit, or delete comments from that row. User story: We have a project schedule template with deliverables, milestones, tasks, and dates. The date rows are locked because they are cell-linked to project…
-
Index/Collect?
I am looking for a formula that will take the "Date Manufacturing" entry for a specific lot number from Sheet 1 (my source sheet, see attachment) and have it automatically populate into a corresponding cell onto a secondary sheet (attachment 2) into the row "Date of Manufacturing" for that specific lot number. I have the…