-
Can I link a cell to a folder on my hard drive?
-
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). - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -…
-
Linked Cells Not Updating
I am trying to figure out why my linked cells are not updating. When I double click on the current value ("TBD" in this case) it opens the source sheet and shows the updated value ("Bridgeport Village" in this case). Right clicking the current value and selecting "View Cell History" shows no change as well. Any idea why…
-
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…