Writing formulas

[MJFIS25]

Hello, I have several formulas in my configuration window-is there a way to write one where it will exclude some data that will get captured in the first part of the statement?

Example- my formula is- if startswith([Application Notes], 'PEND APP INST')then 'Pending Application Instructions' else       there is data that will be captured in this statement that I want to exclude- there are specific details of the data I want to exclude that I can write into a formula if needed- I just was not sure if that could be done and what the formula would look like. Thanks

[AkimasaKajitani]

Hi @MJFIS25 ,

Could you please show more information those are sample input data and expected output?

[grazitti_sapna]

Hi @MJFIS25, if I have understood your requirement correctly what you want is to replace the PEND APP INST in the beginning, here is what you can try I have provided 2 solutions.

Thanks.