I have a custom field that is a text field, Height__c (It was set as a text field from the start, not sure why)
Height__c needs to be compared to a couple of statements:
If height__c is >10" call it"Tall" If Height__c is > 0" but <=10", call it "Short" If Height__c is > 10" but <=20", call it "S-Short" If Height_-c is blank we call it "None"
it also has to be coming from the record_type: Gauze
So far my formula is:
Record_Type_Name__c ='Gauze' && IF(VALUE(HEight__c)>10,'tall', IF(AND(VALUE(HEight__c) > 0,TEXT(VALUE(HEight__c) <= 10,'Short', IF(AND(VALUE(HEight__c) > 10, TEXT(VALUE(HEight__c) <= 20), 's short','None') ) ) ) ))
It is returning the error: Error: Incorrect parameter type for function 'TEXT()'. Expected Number, Date, DateTime, Picklist, received Boolean
I know its difficult because the field type is text, but i want it to convert to a number in the formula to compare it to the statements above but bring back a text field as the outcome. Any ideas what I did wrong?
I dont want to change the field type because it is being used in other api call outs as a text field. the outcome should be a text formula that shows either "tall", "short", "s-short", or"none. Users are inputting 10" or 12" into the text field so I dont know how that can be inputted into the formula field with the " converting to a number field.