Cross Reference
Can you have some rows reference one column in a sheet and other rows reference a different column in the same sheet? It seems like I am getting a message that when I reference a column all 1000+ cells are changed to that reference, but I have 26 rows I want to point to a different column. Do I have to relocate them to another sheet?
Also weird glitch...I have two columns that keep changing from text to date when a save or a new reference comes across about 1/4 of the time causing my columns to blank out. Has happened about 20x in the last 2 days.
Best Answer
-
Ok. So it sounds like you are clicking on "Edit Reference". Instead... Highlight the entire reference so that the cross sheet link in the formula helper box reads "Reference another Sheet". Then try selecting the new column from your source sheet.
Answers
-
Are you able to provide screenshots for reference?
I suggest reaching out to Support regarding the glitch.
-
=COUNTIFS({Month}, 1, {Incident Type}, "Lab Issue/ Delay/ Reporting Issue", {Date of Incident}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))
Trying to change my medication errors to (but the whole sheet changes..not just my selected cells):
=COUNTIFS({Month}, 1, {Medication Variance Type}, "K- Medication given after being discontinued", {Date of Incident}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())
My References are:
(Month)
(Incident Type)
(Date of Incident)
So I get Incident Type or Medication Variance Type, but not both. I'm not sure if this is working as designed.
-
Ok. So it sounds like you are clicking on "Edit Reference". Instead... Highlight the entire reference so that the cross sheet link in the formula helper box reads "Reference another Sheet". Then try selecting the new column from your source sheet.
-
OMG...that freaking worked! Yes I was clicking "edit reference". Me and all the nurses taking care of patients thank you so much!!!
-
Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!
