IF/AND/BLANK Formula Logic

Options
Tony Fronza
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!

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!