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
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!