Formula that compares one cell to another

Can you post a screenshot? Or I would be happy to help outside of this SmartSheet chat?

@alwayslearning

Excellent!

Happy to help!

Easy to miss the commas and everything. We all do it!

Try something like this.

=
IF(OR([Region Total]74 = "", [Region Total]80 = ""), "", 
IF([Region Total]74 = [Region Total]80, "VERIFIED", "ERROR"))

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

All comments

alwayslearning,

This one should work well. The formula would live in the "Verified?" column.

=IF([Test Cell 1]@row = [Test Cell 2]@row, "Verified", "Nope")

Heath - thanks for your response. Unfortunately, this didn't work. All the cells are in the same column called Region Total - including the cells I want to place this formula. I'm trying to compare row #74 with row #80 in this same column.

alwayslearning,

Okay, gotcha. Try this version. Here is what mine is using.

=IF([Test Column 1]1 = [Test Column 1]2, "Verified", "Error")

Yours would maybe be ...

=IF([Region Total]74 = [Region Total]80, "Verified", "Error")

I'm sorry. I'm still getting the message "UNPARSEABLE."

Can you post a screenshot? Or I would be happy to help outside of this SmartSheet chat?

Hi @alwayslearning

I hope you're well and safe!

Strange! Heath's formula should work.

I agree with Heath that it would be great to see a screenshot.

What kind of data do you have in the column?
Is it linked from somewhere else?
Are rows 74 and 80 active (have there been any changes to both rows)?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Screen Shot 2022-01-03 at 7.14.25 AM.png

Heath and Andree,

I can not tell you how much I struggle with this - My eyes get lost in all the commas, quotations, parentheses, etc. I looked at it with fresh eyes this morning. Somehow, I had an extra comma in Heath's formula. I removed it, and it is working! Could I impose on you to add to this formula - if it's even possible? Right now the sheet is blank - except the word "Verified" is in the cell where the formula sits.

Is there any way to add to this formula so that the cell remains blank until numbers are added to the two rows the formula is comparing? If not, no problem. I just love that this will work! Thank you again!

Nancy

@alwayslearning

Excellent!

Happy to help!

Easy to miss the commas and everything. We all do it!

Try something like this.

=
IF(OR([Region Total]74 = "", [Region Total]80 = ""), "", 
IF([Region Total]74 = [Region Total]80, "VERIFIED", "ERROR"))

This worked perfectly! Thank you again! Happy New Year!!!