If one sheet is showing a name in a row how can i highlight the name on another sheet?
Hi,
I have a sheet that populates names and actions next to them. I have another sheet that is names of people in different organisations. How can I Highlight a certain colour on one sheet for the name if the other sheet has the same name (if you know what i mean!!)
Answers
-
In the sheet you want to have the highlight on, you would insert a checkbox type column (can be hidden after setup to keep the sheet clean) and use this formula:
=CONTAINS({Source Sheet Name Column}, [Name Column]@row)
Then you would set up a conditional formatting rule to highlight the name column when the checkbox is checked.
-
Hi Paul
What do I put in that formula you left? I am doing something similar to ady except the column name is VIN
My 2 sheets are Data Sheet for Cell Link and Test Cell Link SS
So would formula be:
=CONTAINS({Data Sheet for Cell Link Column}, [VIN Column]@row)
-
I tried this again today and couldn't work it out still :-(
-
@Ashley Lewis The formula would go in a checkbox type column on whichever sheet you are wanting to show the highlights on.
@ady Are you getting an error?
-
Thanks for the quick feedback, I will check tomorrow at work and let you know.
-
Am I way off here?
-
@Ashley Lewis Your [Column name] should match exactly what is in your sheet.
[VIN Column]
should be changed to
VIN
-
Am I way off here?
-
Still doesnt work
-
@Ashley Lewis Are you getting an error?
-
I am putting in the source SS the column from the other SS but then when i click on the column on the source i need the data to match its giving me UNPARSEABLE
I will take some screenshots tomorrow.
-
I am getting the same thing ady is-UNPARSEABLE
-
@Ashley Lewis Are you able to provide another screenshot with the updated formula?
-
@Ashley Lewis You have a closing parenthesis between VIN and @row that needs removed.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!