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…
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.…
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…
Hello, I have a main tracker (T1) and a sub-tracker used for only one team with limited view (T2). I need to link the tracking cells so someone can enter data on both sheets and it show up on T1. Howe…
Hi I have a sheet that tracks time spent on multiple sites, I'm trying to add this to a metric sheet but struggling to get the metric sheet to add the total time spent against each site as a total. Ca…
I had a formula that was working all through the trials but then right before the roll out it stopped working! In one cell there's a column that Auto counts Responses no big deal there. In a cell in a…
Hi I have two sheets, one acts as a master file for top level view only, the other is a more working doc. On the working doc, I have added a progress column, calculating the percentage of progress of …