-
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…
-
links to pivot sheet cells do not hold the link
I have created a pivot sheet. I then from another sheet link a cell to the pivot sheet but the link does not hold. This just started happening with newly created pivot sheets. I have a number of older pivot sheet created and the cell links are fine. I also use pivot cell links in my dashboard metrics, they are now coming…
-
How to summarize data from multiple sheets without manually linking each cell?
Hello, I'm working on a project with KPIs that will be entered into ~50 individual sheets. I want to be able to roll-up these KPIs into one summary view, but am running into trouble when I pull them into a report because I can't perform calculations in a report. One KPI is Overtime %, so I can't just take the average of…
