Cross Reference

Amy Swan

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.

Paul Newcome

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.

Paul Newcome

Are you able to provide screenshots for reference?

I suggest reaching out to Support regarding the glitch.

Amy Swan

=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())

Capture smartsheet reference 1.PNG

Capture smartsheet reference 1.PNG

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.

Paul Newcome

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.

Amy Swan

OMG...that freaking worked! Yes I was clicking "edit reference". Me and all the nurses taking care of patients thank you so much!!!

Paul Newcome

Happy to help. 👍️