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!
I would like for info entered into Sheet 25 to be automatically updated into Sheet 37. There are no numbers/calculations,- just data & dates, the structure/names of the columns of both sheets are different, child rows are involved. Does anyone know if this is something that Smartsheet is capable of? TIA
Unable to deselect the Template Items in the Blueprint Customize Profile Data section as it is grey out though we have removed Approval column and Target Column, I need to push Intake field only to Metadata sheet and need to remove all other sheets as I have created cell links manually from Metadata to all child sheets.…
I have an old page, created in 2021, in the last few weeks it has started having this message: It has some simple formatting, one column's cell changes color based on status. It has one look up, checking the "PO#" (red highlight) against another sheet, and populating the "Filled Ship Date" (green highlight) formula:…
