Skip to main content

Simple pre-population required

K
Forum|alt.badge.img+3

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

    D
    Forum|alt.badge.img+14

    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
    Forum|alt.badge.img+20

    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.

    JonathanBowen
    1 person likes this
    • JonathanBowen
      JonathanBowen

    Reply


    Most helpful members this week

    Terms & Conditions