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,

Find more posts tagged with

Accepted answers

All comments

James Keuning

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.

Marc M.

@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.

James Keuning

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.