if formula
Hi I was wondering if someone could assist. I'm trying to have a box check if the criteria on two sheets are the same.
Example would:
I have a column called Submission Number on one sheet and I have another sheet with a column with submission numbers. I would like if a number appears on both sheets I would like to check a box.
=IF([Submission Number] @row= {Submission}, 1, 0)
Thanks
Answers
-
Hi @kari1282
Hope you are fine, as i understand from your scenario you are submitting "Submission Number" randomly in the tow sheet and you want in sheet1, for example, to check the box when the same "Submission Number" is submitted in sheet2. if this is what you want please try the following formula:
=IFERROR(IF(COUNTIFS({Sheet 2 Submission Number Range}, [Submission Number]@row) >= 1, 1), "")
the following screenshots show the results:
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!