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!
Hello, I have a data tracker that has a column with different company names. It is a free text column from a form. In my calculation sheet, I need a formula to pull in those company names from the data tracker. Is it an Index or VLookup formula? Thanks in advance.
Hi, I have a SS Form to capture my team's attendance on a daily basis, specifically the dates, leave type. I am capturing the employee's name using the Contacts type field in the form. Now, on the form, when I make an entry for a specific name, dates and leave type, is there an option to detect if the same entry was…
The formula has been corrupted and all we have are 0's. They are in our PO Expenses but not syncing with the job.
