Variables in forumulas


#1

Hi,

can i do a formula to replace a certain word in a column

column a = month
column b = adtext containing text including [MONTH]
column c = adtext with text replacing word [MONTH] with column a

Thanks!


#2

Hi @Carl-Henrik_Sjostrom

You could use the Substitute formula function in Column C like this:

SUBSTITUTE({Column B},’[Month]’, {Column A})

I suggest you have a look at Airtable’s formula reference here:

Formula Field Reference

Hope this helps!


#3

Amazing, thanks @Julian_Kirkness!