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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Are you able to provide screenshots for reference?
I suggest reaching out to Support regarding the glitch.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
=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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 303 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!