Hi all, i'm trying to find the minimum of a c...

(Ivan Oboth) #1

Hi all, i’m trying to find the minimum of a couple of columns of type “percent” within a record but i get the error “LIST has elements of mismatched types” This is the formula im using, all the fields being used are of type :“percent”

MIN({[Plan],[Connect & Create],[Align-Persuasive Sell],[Execute],[Evaluation (Call)],[Evaluation (Self)]})

Could i be doing something wrong?

(Bellave Jayaram) #2

Try MIN(LIST([Plan])+LIST([Connect & Create])+…

(Praveen Seshadri (AppSheet)) #3

Or MIN(LIST([Plan], [Connect & Create], … ))

(Ivan Oboth) #4

Awesome, thanks @praveen, @Bellave_Jayaram