If and Find

Debbie JDebbie J ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
02/16/18 Edited 12/09/19

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

 

Comments

  • find returns the position at which the string is found

     

    =If(find("ABC",A3,)=1,"ABC","X") 

  • Debbie JDebbie 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.

     

    Thanks

     

  • Mike WildayMike 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 JDebbie 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 WildayMike 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!

Sign In or Register to comment.