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

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!