What is wrong with this formula
Hi,
Im am trying to use this IF statement to check if the rows of 1 sheet have the same sections as the row on my current sheet and if it is true we return true. However, I cant seem to get this forumla to work. I was trying to add a @ row to the reference to the other sheet but it gives me an error. but if i just reference the column from the other sheet, it also gives me an error.
Answers
-
Hi. So the issue your if statement is comparing an entire Range to the section@row. Refrences wont work that way. Instead try using a count if statement. IF(COUNTIF({Refrence from other sheet}, = Section@row) >0,"True","False")
This will count every row you have that matches that particular range "Section@row" If it finds any rows that match it will flag it as true.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!