Variables in forumulas



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



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!


Amazing, thanks @Julian_Kirkness!