Help

Variables in forumulas

1442 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Carl-Henrik_Sjo
4 - Data Explorer
4 - Data Explorer

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 Replies 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!

Carl-Henrik_Sjo
4 - Data Explorer
4 - Data Explorer

Amazing, thanks @Julian_Kirkness!