Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula to calc rating based on other fields

Topic Labels: Formulas
537 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi. New to Airtable. Looking to add a formula field that calculates a value (rating - via stars) based on data in other fields. In the attached example, I’d like the ‘Expected Rating’ field to return a star rating (via star emoji) based on the completeness of the other fields.

image

1 Reply 1

Hi @VC_Hacks - you can do something like this:

REPT('️', IF({Field One}, 1, 0) + IF({Field Two}, 1, 0) + IF({Field Three}, 1, 0))

Screenshot 2020-11-18 at 21.18.47