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
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!