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.

Help with Formula using REPT

Topic Labels: Formulas
373 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello.

I have two tables. Hardware and Ratings. Hardware is linked to Ratings and rolls up different ratings for hardware records.

I have a roll up field in the Hardware table called ‘Average Rating Back’ which rolls up all the ratings (from the Ratings table) per hardware record to create an average. The formula I’m using here is:

IF(ISERROR(AVERAGE(values))=0, AVERAGE(values), BLANK() )

I have a formula field as below in the Hardware table which converts the roll up fields integer and turns it into stars (essentially an average rating).

IF({Average Rating Back}="",“This hardware hasn’t been reviewed yet”,REPT(“ :star: ”, {Average Rating Back}))

If I don’t have an integer in the roll up field then the text will appear as per the IF statement. If I do have an integer then I use REPT to show a star per integer i.e. 2 = :star: :star: .

This was all working fine until I just received an #ERROR! after the roll up field rolled up a ‘5’ and a 4’ rating for a hardware record.

Do you know where I’m going wrong?

Thanks!
Dan

0 Replies 0