Help

Formula to calc rating based on other fields

Topic Labels: Formulas
1118 1
cancel
Showing results for 
Search instead for 
Did you mean: 
VC_Hacks
4 - Data Explorer
4 - Data Explorer

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