Auto Populate cell with a symbol in front of the value

James Preston

Hi guys, I have created an intake form and one of the values should be numerical only (i.e. volume spend) for consistency of data. So, I want the end user to apply only the numerical value on the form e.g. 80 but then on the sheet I want it to appear with a dollar sign ($) i.e. $80.

Is there a way to do this?

mcullen

Hello @James Preston,

There is a way to achieve this. Go to Edit your form and click on the column where you want a numerical value. On the right side under Field Settings, scroll down to Validation and select Number only. I would also add "Help Text" stating, "apply only the numerical value on the form e.g. 80". Then save the changes.

Next, go to your sheet, click on the column with the numerical value, then click the three dots (near Share in the upper right corner), and select $, then the applicable currency.

Hope this helps!

mcullen

Hello @James Preston,

There is a way to achieve this. Go to Edit your form and click on the column where you want a numerical value. On the right side under Field Settings, scroll down to Validation and select Number only. I would also add "Help Text" stating, "apply only the numerical value on the form e.g. 80". Then save the changes.

Next, go to your sheet, click on the column with the numerical value, then click the three dots (near Share in the upper right corner), and select $, then the applicable currency.

Hope this helps!

James Preston

Can't believe I missed the column currency setting! Thanks so much!!

mcullen

@James Preston you're welcome! Take care!