Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to perform function Replace if condition is met?

991 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?