Guest Name Cross Reference between sheets
Options
MeganHaro
βββ
I keep a running list of guests, and currently have one sheet for 2023, and a second one started for 2024. Is there a way to flag/highlight a duplicate name if the same guest (from 2023) was added to the 2024 sheet?
Best Answer
-
You would use something along the lines of
=IF(COUNTIFS({2023 Sheet Name Column}, @cell = [Name Column]@row)> 0, 1)
Answers
-
You would use something along the lines of
=IF(COUNTIFS({2023 Sheet Name Column}, @cell = [Name Column]@row)> 0, 1)
-
I will try that, thank you Paul!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!