HockeyDiablo
Board Regular
- Joined
- Apr 1, 2016
- Messages
- 182
Here is where I am going with this. But where am I going wrong? all type(2). Formula in Col8
-I'm getting tied up while trying to ensure the first 2 characters in column2 is a number "0-9"
SO heres an example:
[TABLE="width: 800"]
<tbody>[TR]
[TD="align: center"]Col2[/TD]
[TD="align: center"]Col3[/TD]
[TD="align: center"]Col4[/TD]
[TD="align: center"]Col5[/TD]
[TD="align: center"]Col6[/TD]
[TD="align: center"]Col7[/TD]
[TD="align: center"]Col8[/TD]
[/TR]
[TR]
[TD="align: center"]Jon Doe[/TD]
[TD="align: center"]123 Main St[/TD]
[TD="align: center"]Acity, MN 55304[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: center"]Jane Buck[/TD]
[TD="align: center"]SP 199, Cbl 59[/TD]
[TD="align: center"]456 Main St[/TD]
[TD="align: center"]Acity, MN 55304[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: center"]Johnny Walker[/TD]
[TD="align: center"]Removed debris before job[/TD]
[TD="align: center"]Call 612-111-1111[/TD]
[TD="align: center"]789 Main St[/TD]
[TD="align: center"]Acity, MN 55304[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
</tbody>[/TABLE]
**I am working within a table**
-I'm getting tied up while trying to ensure the first 2 characters in column2 is a number "0-9"
=IF(AND([@Column2]>0,isnumber(left[@Column3],2*1)=TRUE,[@Column3],""),[@Column4]>0,[@Column5]=0,[@Column6]=0,[@Column7]=0),TRUE,FALSE)
SO heres an example:
[TABLE="width: 800"]
<tbody>[TR]
[TD="align: center"]Col2[/TD]
[TD="align: center"]Col3[/TD]
[TD="align: center"]Col4[/TD]
[TD="align: center"]Col5[/TD]
[TD="align: center"]Col6[/TD]
[TD="align: center"]Col7[/TD]
[TD="align: center"]Col8[/TD]
[/TR]
[TR]
[TD="align: center"]Jon Doe[/TD]
[TD="align: center"]123 Main St[/TD]
[TD="align: center"]Acity, MN 55304[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: center"]Jane Buck[/TD]
[TD="align: center"]SP 199, Cbl 59[/TD]
[TD="align: center"]456 Main St[/TD]
[TD="align: center"]Acity, MN 55304[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: center"]Johnny Walker[/TD]
[TD="align: center"]Removed debris before job[/TD]
[TD="align: center"]Call 612-111-1111[/TD]
[TD="align: center"]789 Main St[/TD]
[TD="align: center"]Acity, MN 55304[/TD]
[TD="align: center"][/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
</tbody>[/TABLE]
**I am working within a table**
Last edited: