Variables in forumulas

[Carl-Henrik_Sjo]

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!

[Julian_Kirkness]

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!

[Carl-Henrik_Sjo]

Amazing, thanks @Julian_Kirkness!