-
INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…
-
Merged: Cell/row linking within the same sheet
This discussion has been merged.
-
Create column links function
Hey everyone, I am trying to use the Create column links function, but the button is in a passive status. Is that because of our company is still uses the Team plan?
-
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…
-
Need Formula with nesting IF's help
Hi folks! Brand new to the community and this is my first help request. I've watched many you tube videos and read as much in the forum as I could about smartsheet formula's, but I just can't figure out what I'm doing wrong. Let me set this up for you: I'm trying to take names from a column in sheet 1, and convert them to…
-
Two Sheets in One Report using same column
I have two sheets referenced in a report. Both sheets have column "A" which is a date column. Since Sheet #1 is the source, I would like to only pull column "A" from Sheet #1. Sheet #2 references(using formula to index match) Sheet #1's column "A" just for information. It seems when I use only Sheet #1 in the report, I can…
-
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…