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 need some help with the following formula: =WORKDAY(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1, 0) The formula stopped working this morning, and is now showing #INVALID VALUE instead of the date (I'm expecting 12/31/2025). Can someone tell me what is wrong with the formula that it's not giving me a date?
Hello all, Running into issues with a new set of syntax I'm trying: =COUNTIF(CONTAINS("2026", {sheet being referenced column}), "True") Keep getting a return of 0, even though there are projects releasing in that referenced column. Thanks in advance!
Im looking for a formula to calculate difference between two times eg 08:00 - 10:00 should give a duration of 2 but running into errors. I have column types as text number. 08:00 is named Start Time and column for 10:00 is finish time
