I have a basic formula I can't get to return a B ball when there is an empty cell.
=IF(Count@row = 0, "Green", IF(Count@row > 0, "Red", IF(Count@row = "", "Blue")))
Move that argument to the beginning.
=IF(Count@row = "", "Blue", IF(Count@row = 0, "Green", IF(Count@row > 0, "Red")))
Try this one instead...
=IF(Count@row = 1, "Green", IF(Count@row = 0, "Blue", "Red"))
Thank you Paul. That did the trick. I'm new at this and am learning :). I have another quick question:
=IF(Count@row = 0, "Blue", IF(AND(Count@row >.01, count@row <1, "Red", IF(Count@row = 1, "Green"))))
0=Blue
Between .01-.99 =Red
1=Green
You're great! Thank you.
Happy to help! 👍️
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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.