IF/AND/BLANK Formula Logic

Tony Fronza

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!

Tony Fronza

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

Paul Newcome

Happy to help. 👍️

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

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. 👍️