Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

How to perform function Replace if condition is met?

982 2
cancel
Showing results for 
Search instead for 
Did you mean: 
NEF1QLSZ4U
6 - Interface Innovator
6 - Interface Innovator

How to perform function Replace if condition is met?

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Are you asking how to nest formula functions inside each other?

IF(

  condition,

  SUBSTITUTE( string, old_text, new_text)

)

Can you give an example of what you want?

NEF1QLSZ4U
6 - Interface Innovator
6 - Interface Innovator

ReplaceValueIFConciitionIsMet.jpg

 

If I use FILTER, it is not possible to add replacement. So, replacement is not like Excel. Should we use code inside another filed not FILTER?