-
Is there a way to have dynamic cell updates? My previous attempts were unsuccessful.
I have two (or more) sheets, one sheet called “Master Sheet” and another called “Library 01”. I want to create a drop down in Master Sheet with Options “A-H” which populates data from Library 01 and automatically changes based on the option chosen from Master Sheet. Is regular Smartsheet capable of this? I've tried using…
-
Keyboard Shortcut for "Link from cell in Other Sheet" aka "Cell Link"
I have to cell link from other sheet quite often. Right click on mouse, then select "Link from Cell in Other Sheet…" every time gets very old and not great for my wrist. Please add these keyboard shortcut! 🙏 Thank you!
-
Ideas on how to effectively create a new sheet that collects information to update status on another
I am struggling to find other answers on the community for this situation. We are creating a log of all equipment. I am creating a second sheet for when that equipment is removed. When someone submits through a form that equipment is removed, I would like the second sheet to automatically update the status on the original…
-
Can I link a cell to a folder on my hard drive?
-
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…