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.
Nov 16, 2020 09:52 PM
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.
Nov 18, 2020 01:20 PM
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))