IF Formula Help
Hi,
I have a column labeled 'Flag' that uses the formula =IF([Calculated Total]@row < [Total Dollars on Invoice]@row, "FLAG", " ") that either is showing as blank for all rows or if I flip it shows as 'FLAG' for all rows.
The 'calculated total' column is a sum of several other columns and the Total Dollars column is just data that is entered via a form or manually into the field.
I'm not sure what I'm missing.
Thanks,
Answers

Are you sure Total Dollars is an actual number? You can use ISNUMBER to test.
I assume Calculated Total must be a number if it's a result of a SUM formula.
If either of the values are not a number, you will get the result you are getting.

@James Keuning If you are referring to the column types, they are both text/number.
I have noticed that if new data is added to the sheet via the form it is working correctly, it's the old data I imported from Excel that it's not working for.

Try putting VALUE in front of the numbers. Or create a helper column, and use a column formula to put VALUE in front of every value and use this column in the formula.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 123 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!