Jul 10, 2019 02:45 AM
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
Jul 10, 2019 05:31 AM
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.
Jul 10, 2019 09:26 PM
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.