IF/AND/BLANK Formula Logic

I'm trying to write a formula to reflect a progress % (using the bar symbol) based on three fields, where one field, if filled in, counts as 25%, the second field, if filled in, counts as 25%, and the third field, if filled in, counts as 50% (to equate to 100%). I'm using =IF(AND(NOT(ISBLANK, but I'm receiving errors. I may be overcomplicating this. I assume the fields I'm using are unnecessary to include in this question, but I can certainly do so if that helps!

Find more posts tagged with

Formulas

Accepted answers

Tony Fronza

You da man, @Paul Newcome! That works perfectly. Thank you!!!

Paul Newcome

Happy to help. 👍️

All comments

Paul Newcome

Are you able to provide some screenshots for context?

Tony Fronza

@Paul Newcome Yes! Thank you for responding. I've attached a screenshot. The LTC Progress is the column I want the formula to be in. I want to show that when LTC Intro Meeting Completed is filled in, the progress bar shows 25% full. If Both LTC Intro Meeting Completed AND LTC SME Meeting Completed are filled in, the progress bar shows 50%. And if LTC Intro Meeting Completed, LTC SME Meeting Completed, and LTC Quote/Proposal Issued are filled in, the progress bar shows 100%.

ABS Tracking Sheet Screenshot for Formula Assistance.png

Paul Newcome

Try this:

=IF([LTC Quote / Proposal Issued]@row <> "", "Full", IF([LTC SME Meeting Completed]@row <> "", "Half", IF([LTC Intro Meeting Completed]@row <> "", "Quarter", "")))

The above is assuming they are filled in in that same order every time.

Tony Fronza

You da man, @Paul Newcome! That works perfectly. Thank you!!!

Paul Newcome

Happy to help. 👍️

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.