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 outst…
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 b…
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 ne…
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 she…
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 m…
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 displ…
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 brok…
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 aro…
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 …
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 shee…
