Help

Simple pre-population required

867 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kate_Aldworth
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

Very simple formula needed but drawing a blank as to how to do it. I need a column with a £value in it pre-populated when I create a record. i.e. =£10 I need it to be a £ as it will generate a forecasted figure…

Thanks in advance
Kate

2 Replies 2

I’m sure there are many ways to do this, but here is the first that came to my mind…

IF(CREATED_TIME(),10,BLANK())

All records will have a created time so this will always evaluate as TRUE. Used the formatting tab to make this field display as a currency.

Make a Currency field. In the Format tab for setting up the field, set the currency symbol to £. In the Default tab, set 10 as the default value.