Invalid Data Type Error

I'm trying to have a symbol turn "yellow" if the number of check boxes in a selected is even (and >0), or "red" if uneven. To do this I made a hidden column with a formula counting how many boxes were checked:

=COUNTIFS([ColumnA]@row:[ColumnF]@row, 1

Then in the symbol column, wrote the following formula:

=IF([HiddenColumn]@row >= 1, AND(IF(ISEVEN([HiddenColumn]@row), "Red", "Green")))

But now I get an "Invalid Data Type" error message in the symbol column when any amount of boxes are checked. Help please!

Find more posts tagged with

Accepted answers

All comments

James Keuning

=IF(HiddenColumn@row > 0, IF(ISEVEN(HiddenColumn@row), "EVEN", "ODD"), "")

If it's bigger than zero, test for EVEN/ODD and return EVEN or ODD. If it's not bigger than zero, then blank

Genevieve P.

Hi @tbelly50

I see you marked James' answer as not resolving your question. I notice you have the AND function in potentially the wrong place, if you're looking for both conditions in the first IF statement.

Try:

=IF(AND([HiddenColumn]@row >= 1, ISEVEN([HiddenColumn]@row)), "Red", "Green")

If this is still returning an error, it may be that your hidden column has an error. Check to see if your COUNTIFS is in the right type of column (text/number).

Cheers,

Genevieve

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.