If and Find

Debbie J
Debbie J ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

If cell A3 contains "ABC" then enter "ABC" in cell A1.

Can someone help me do this in smartsheet?


I tried using =If(find("ABC",A3,)="ABC","ABC","X")  but its not working.


Thank you



  • find returns the position at which the string is found



  • Debbie J
    Debbie J ✭✭✭✭✭✭

    OK what will confirm if there is that text .

    For example  Credit data ABC 145.... it needs to confirm if there is abc in the string of text.




  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    edited 02/16/18

    Hi there, are you working in Excell or in Smartsheets? Smartsheets does not refer to columns by A, B, C as Excell or Google Sheets does. To reference a column you have to use its column name. 

    Rjudenberg's solution will work, but you have to modify it with the Smartsheet Column Names. 

    =If(find("ABC", [Column A Name]3)=1,"ABC","X") 

  • Debbie J
    Debbie J ✭✭✭✭✭✭

    I am working in smartsheet thank you both for clarifying. I actually need to change the =1 to a >0 and make sure I match the exact text. My cell was in all caps and I didnt use that the actual formula.


    Thank you both


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    =If(find("ABC", [Column A Name]3)>0,"ABC","X") 

    This should work You just need to replace the Column A Name with your own column name. 

  • Thank you Smartsheet Community! I love you!