Forum Discussion
Help with challenging formula
Hello! I need help figuring out how to get a formula to work and was counting on this community's expertise! I basically have a table with ticket items where one of the columns for each ticket i...
ragomes1972 It isn't pretty but this formula will give you a helper column to determine if that row meets the criteria:
=LET(in,E2,lenIN,LEN(in),xploded,SUBSTITUTE(in,";",REPT(" ",lenIN)),n,IFERROR(CEILING.MATH(LEN(xploded)/lenIN,1),0),list,IF(n,TRIM(MID(xploded,SEQUENCE(n,,1,lenIN),lenIN)),""),storys,FILTER(C:C,B:B="Story"),st_true,OR(IFERROR(MATCH(list,storys,0)>0,FALSE)),b_true,AND(B2="Bug",F2="Yes",st_true),--b_true)see attached
Thanks, mtarler!
This is great but I'm wondering if there's a way to achieve the result without the use of a helper column or table through a single formula.
Let me know if you have any thoughts on that.
I truly appreciate your time to help with this!
This is great but I'm wondering if there's a way to achieve the result without the use of a helper column or table through a single formula.
Let me know if you have any thoughts on that.
I truly appreciate your time to help with this!