-
Automatically linking cells when a new row is added to a sheet
I have two sheets. Sheet 1 contains primary data, the other secondary. When a new row is added to sheet 1 I want to be to create a new row in sheet 2 that contains the information in specific cells from sheet 1. I want that link to work such that if Sheet 1 is updated that is reflected in sheet 2 - the sheets stay in sync…
-
Collaboration with multiple sheets and a single, "external" user.
Hello, We've built an environment for our budget process that has a dedicated Smartsheet for our various regions, each of which has a dedicated Dynamic View. This allows our HR team to work collaboratively with our Finance team. The HR team has access to the underlying sheet while finance has access to the Dynamic View. We…
-
Attendance reports
I am trying to create a sheet for attendance reports. We take daily attendance of our students, but it is done on a form which is part of a bigger report. I would like to provide the front office with a monthly report of just the students that were absent and which days. How would I do this? Hyperlink? Condition? Please…
-
Is it possible to remove a cross sheet reference when a condition is met and keep the data?
I have an interesting scenario where I have a cross sheet reference that pulls a current outstanding total from another sheet. This works perfectly but we want to keep history of what this total outstanding value was at the end of each day. The image below should help explain the scenario. Essentially what I want to do is…
-
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…
-
Cell linking automation
I've been able to link cells from sheet to sheet but I can't find resources or videos on how to automate the process. I have to manually type the formula in the column of the other sheet whenever a new row is added to the master. I have a master sheet. When a certain status is selected at a row level, I would like to…
-
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…