-
Proofing While Hiding Columns
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 columns). Dynamicview does not appear to allow for proofing, and a report would require sharing the entire base sheet. External…
-
Anybody Find a Workaround for Accessing Sheet Summary Fields Across Sheets?
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 from other sheets. Has anybody found an work around? My attempt at a workaround: I tried creating a hidden column that grabs…
-
Creating unique participant IDs
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 like to have the corresponding sheet automatically generate a unique ID for each person that is de-identified. Is there a…
-
Display date and duration by referencing other cells in the same sheet
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 reflected in row 3. Likewise, =[Finish]@44 doesn't reflect the Finish date from row 44. =[Duration]@44 or =Duration44…
-
Cell Linking And Referencing Sheet Summary Fields From Other Sheet
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 the Sheet Summary fields from Sheet1 (or any other sheet). - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -…
-
Links and Archiving?
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. Ideally I want to save a new version of each of the two sheets and archive those new versions and have links retained so that I…
-
Can you cell-link within the same sheet?
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 then in the cell, have a link that takes the user to row 100, 140, or 170. I know you can cell-link to other sheets in a…
-
I need a modification on an IF THEN statmenet
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 all children of that row will show "Task 2". I did that using this formula: =IF(Level@row = 2, LEFT([Task #]@row, 7),…
-
New reference range in a metrics sheet is not working.
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: {All Action Items Status1} and {All Action Items Resp Org Map}, which exist as a reference ranges. My original formula for…
-
Any idea what I could be doing wrong?
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 stay updated as the project progresses. So, a couple of things need to be taken into account, the info displayed needs to meet…