Formula for Number or text

Highlighted
Occasional Contributor

Formula for Number or text

Hi,

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

Thanks

1 REPLY 1
Highlighted
Certified Master Anaplanner

Re: Formula for Number or text

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