Formula for Number or text


Is it possible to format a line item so users either input a number % or "n/a"?   



  • Hi @CommunityMember113484 ,


    I don't think you can have a field be both number and text as a type. To work around this, you can have an input line with Text format. Then to evaluate the field, you can create a separate line item with Number format and use the VALUE() function.

    Not sure what your use case is, but this should allow user input for both numbers & text.