simple comparison


I can't believe I have to ask this, but I cannot turn up a solid answer when I search.

I just want to compare Column2 value with Column1 value. I want the formula/result to be in Column3.

I get UNPARSEABLE. The best formula I could find was: =IF([TotalRegistered] = [RegistrationCap], "SOLD OUT", "").

The only thing I can think is that Column1 and Column2 are both linked in from another sheet. Is that the reason this won't work?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!