Pre-populate text fields from another table

[Kate_Aldworth]

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

[David_Skinner]

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.

[Justin_Barrett]

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.