Simple formula to show if two cells match- what am I doing wrong?
Hey everyone,
I am having trouble with what I thought would be a simple formula:
I have a sheet that is drawing information from two different sheets via cell linking and a SumIf formula:
Total Order Cost, which is linked to one sheet and Invoice Total, which is summing all cells that match my primary column, which is also linked to the same sheet the Total Order Cost is linked to, and adding the amounts in a different sheet.
I am trying to have a column show whether or not the two cells match.
Example is this:
Total Order Cost: $740.00 (linked cell) Invoice Total: $740.00(SumIf formula referencing different sheet) - I want the cell next to these two to either say yes if they match, or show a RYG ball, anything.
I keep getting #unparseable or other errors, and can't figure out why ( I have looked at the definitions, and checked the spellings, etc)
Is this not possible due to the formula and cell linking? Or am I too close to see the problem?
Thank you in advance for any help!
Comments
-
Can you post your formula? I ran a quick sample using this basic one and it was working correctly for me.
-
I just tested too and am not having any errors.
=IF([First Value]@row = Second value@row, "Yes", "No")
Seeing your actual formula and possibly some screenshots would definitely help.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!