Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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
=If(find("ABC",A3,)=1,"ABC","X")
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
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")
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
=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!
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
I have a sheet with 5000 rows and 30 columns. with 4 columns of them are formular columns. How can i reach this limit for 25000000 formular cells reference? How can i enlarge this limit? I need those formular to link some data from another sheet as there is also Max cells limit for one sheet. How can I join those data…
