-
Cell Linking to Sheet Summary Field
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?
-
Send alert when user hasn't accessed sheet in X days
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…
-
Can I conditionally format a cell if it contains text from a range consisting of multiple rows?
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…
-
Removing Links
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!
-
Cross Reference Report - Workaround Ideas
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.…
-
Linking rows as they are copied to other sheets.
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…
-
CONTAINS not finding match in second sheet
Looking to create a count of the number of times a name appears. in another sheets column. I keep getting a false result. =IF(CONTAINS({EE Schedule Range 3}, {EE Schedule Range 2}), "Yes", "No") Range 3 is with in Range 2 on second sheet. For this example Range 2 is a list of names and Range 3 is one of the cells in that…
-
linking rows across different sheets
Ok this one seems to be a little more advanced of a question, once a row is copied to another sheet is there a way to link the the copied row to original row so that whatever changes are made to the copy also happen to the original row. lengthy description below with screen clips. the first screen clip is the master list…
-
Is there a way to pull info from a form submission and enter it into another form?
I have a form I am currently running, that whenever answered, needs to be reviewed by another person. I am currently using the approval workflow, and putting it in the email with a link to a form that the reviewer needs to fill out. Is it possible to take the info given from the previous form and put it in the next one so…
-
bulk update individual cell references at the same time.
I have a scorecard that pulls data from several other spreadsheets, all of which are specific to different years. With the new year approaching, I aim to generate new copies retaining the same workflow and linked sheets. Is there a method to duplicate all sheets with new year specific names while maintaining the existing…
