What is wrong with this formula

Options

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

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    Options

    @BrendonL

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!