Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Simple pre-population required

1349 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.