"Number" column with added Text

AppSheet AppSheet Q&A
1

Hello Dear Community.

Is this possible, trough any direct formula, (so not usinga second utility column or VC) to have a “Number” with text column…

So being able to launch calculations from this value, and to still show some “Text” info (Like units):

For example I have a “Bandwith” column, where I want to add “Mbps”, after the numeric value (for display) but still be able to reference the number for calculations

1000 Mbps

I could use 2 Column , one with Text and a CONCATENATE(TEXT( formula to reference the other number Column, which could be used for calculations. But if I can only use 1 column it would be great !

thanks and best regards !

2

Nope.

2 Likes
3

It is not as user friendly as having a suffix of units but one somewhat intermediate user experience alternative could be to display the units of measure in the column’s display name itself such as "Bandwidth (Mbps) " or “Weight (Kgs)” and so on.

2 Likes