Simple pre-population required

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

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.

1 Like