if formula help

Dale Terry - 4QCAC

I am trying to do a formula that states: if there is text in the column2 then place a "1" in the primary column. @Paul Newcome

Mike Wilday

You could approach this a couple different ways. Without knowing for sure your use case, I will post two different options.

=IF(istext([column2]@row), 1, "") -- this formula checks to see if what was entered in column 2 is actually text., a number input will fire a blank response in the primary column.

=IF(isblank([column2]@row), "", 1) -- This one checks to see if the Column2 is empty or not. If it is empty then it leaves it blank, if there is data in column2 of any kind, it will add your 1.

Dale Terry - 4QCAC

Ok one last question what if I wanted to reference the entire column? so if any text appears any where in column2 then the return should be 1

Dale Terry - 4QCAC

I thought this would work but I get an error. =IF(ISBLANK([Column2]:[Column2]), "", 1)

Mike Wilday

I would do a combination of a countifs statement and an IF statement.

=IF(COUNTIFS([Test2]:[Test2], NOT(ISBLANK(@cell))) > 0, 1, "")

Here is a video of that working.

https://drive.google.com/file/d/1mz5DjpR4kfagccVdGAXZ5AFD7IhlH-ep/view?usp=drivesdk