-
Linked Source Sheet Not Automatically Updating
Hello, I am working on creating a sheet that utilized data from a master sheet via links. I am struggling because the new sheet is not automatically updating when new info is added from the master sheet which essentially makes it useless. Is there a way around this? For what I am trying to create, I need the full…
-
Formula Assistance with Linking Sheets
Hi! I have created a sheet that uses a form for requests when my company is wanting a physician to travel. This includes what center/state they're traveling to, their home center/state, the district manager that oversees each center, etc. When a physician is selected I would like for the home center, home state, home…
-
Attachment Hyperlinks
Hi! I am trying to use connect a cell with an attachment on the same row as the cell so that I can display the information in a dashboard. The goal is that when a user clicks on the cell that is displayed, it opens the attachment it is linked to. I can add links for documents outside of Smartsheet, but the link for the…
-
Vlookup - #unparseable result
I built a tracker that is populated with an intake form. One of the criteria is a broker code, that when entered on the tracker from the form, is vlookup’d from a reference sheet and gives me the broker’s name, their branch code and branch name. This works perfectly fine for our purpose. Our team has now been tasked with…
-
Link to Individual Card View?
I want to display a card when a cell is clicked. Is this possible? I used the row link and hyperlinked it to a cell but when you click it brings up the entire grid in another browser with a border around the individual card. Is there a way to click a cell and have just that individual card pop up without sending you to the…
-
I need help rolling up multiple weeks of data into one response based on specified criteria
I currently have a sheet that collects weekly attendance info from multiple stakeholders (for the purpose of this question we can just look at the Coach Info columns). There are 3 responses that can be put into this column: 'Yes', 'Some, and 'None'. My second sheet is a monthly tracker in which I am trying to read four…
-
Is a cell value driven cross sheet formula possible?
Our projects have a subfolder with any number of sheets that all have the same data layout. We need a summary sheet that fetches a status value from each child sheet, but i can't figure out how to do it in a way that wouldn't take 90 hours of tedious work - that would need to be repeated forever and ever In excel i'd use…
-
Adding Cell Links to Existing Profile Data
For a period of time, 2 profile data fields were incorrectly set to One Time Write, rather than Cell Link. I need to correct this and add the Cell Link behavior for these 2 fields from the intake sheet to metadata sheets. I have tried the Add Profile Data trick to apply a pseudo Update Reporting Global Update, however that…
-
Limit increase: 500,000 inbound cell links
Hi Community, Now all users on all plans can add up to 500,000 inbound cell links in their sheets, allowing you to consolidate information by linking cells between sheets. Learn more about cell links. Catch up on how Smartsheet is investing in scale and reliability by reading VP of Engineering Gihan Munasinghe's recent…
-
Linking a cell issue
I linked a cell from another sheet that had a simple formula but the information doesn't show in the cell through the link. I have removed the link, saved then added it again. It's been saved and I've checked the font color. Any ideas?
