Formula for Number or text

CommunityMember113484
CommunityMember113484
in Modeling

Hi,

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

Thanks

Tagged:

Answers

  • jackcplanning
    jackcplanning

    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.

     

    foto.PNG

Categories