if formula help
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
Answers

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.

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

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

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/1mz5DjpR4kfagccVdGAXZ5AFD7IhlHep/view?usp=drivesdk
Help Article Resources
Categories
Check out the Formula Handbook template!