Hey Smartsheet community, We want to utilize the proofing feature with our customers while in the same sheet hiding specific columns just from the customer (while allowing our team to see those column…
I would like to be able to access Sheet Summary fields from sheet to sheet. You can access them from Reports as well as Dashboard Metric Widgets, but cannot access them by cell linking or references f…
Hi all, I am looking for a way to generate unique IDs for individuals filling out forms. We have a number of events for which we have made registration forms. When a person fills out a form, we would …
Hello Everyone, I'm trying to reference data from row 44 into row 3 in the same sheet. "=[Task Name]44" works like a charm (see below). However, =[Start]44 doesn't result in the date "08/13/25" being …
Sheet1 has Sheet Summary fields. Sheet1 can access it's own Sheet Summary fields. A Report can access the Sheet Summary fields from Sheet1 (or any other sheet). A Dashboard Metric Widget can access th…
So, I know that if you automate rows/cells to move to another sheet it removes links, but I have two sheets that are linked to one another that I want to archive and retain the links between them. Ide…
My team is tracking product development for a project and we want to be able to reference multiple rows within the same sheet. For example, in row 20 we want to have a column labelled "Refer To" and t…
I have a column in my grid that generates the Task number automatically for Level 2 and all of the children below it. IE if I choose the drop down "Task 1" for a row that is level 2 then that row and …
This one has me baffled. I have added a row to a large sheet. I notice it does not show up in any of my metrics calculations after the add. In my metrics sheet, I refer two ranges in another sheet: {A…
Hi all, I need to create a formula that will collect info from a different (original project) sheet and display the right data on the cell of a new sheet (used to build a report) - that way things sta…
