This discussion has been merged.
I have a Master sheet I am trying to pull in data from other sheets on. One of the other sheets I am linking from has several sheet summaries. I need that summary, which has the sums of several columns) on my Master. Is there a way to link to that summary so it is always updating on my Master?
Is there a way to link a cell from one sheet to another, but only link over the latest change from changed cell?
I have two cells that I would like to sum together based on a check box. When Order Received is checked, Quantity Delivered is then sent into my total inventory in row 1. I would then like to clear all of the contents of row 2 through an automation, because that order is complete and done with, without changing my new…
I like the function of the Sheet Summary but what I am curious on is how would one link a cell to one of those Values. Also how do we see the historic values for these fields?
Hey there - I'm trying to set up an alert redirecting users to my sheet to make sure everyone's using it and gently nudging them if they aren't. Here's the logic: IF they a) have permissions to access the sheet AND b) haven't accessed it or changed anything within the last 20 days. THEN Send a message including a link to…
I have a column containing text (multiselect drop down) that I would like to eventually conditionally format based on the presence of matching text from cells in a range made of multiple rows. Here is fictitious data in an excel format for simplicity. Sheet 1 Range 1 (Column C) contains the data I want to format based on…
I accidently added linkage from one sheet to another. How do I remove those linkages? There are a total of 10 rows and 12 columns that were linked. Thanks!
Hi, I know that I cannot cross reference a report; I'm hoping someone might have an idea on a workaround. I have a report that gathers data from all sheets in a specific folder. The quantity of sheets varies around +/- 200. I want to get one summary field (to match on) and the sheet link from each sheet into another sheet.…
I have 3 sheet across 3 different departments. first being the master sheet where the majority of information is collected. as selections are made in certain columns the row is copied to other sheets. Is there a way to link entire rows together so when attachments or other cells are filled in on 2nd and 3rd sheet, the…
