Sign in to join the conversation:
Hi,
I am trying to write a formula that returns a flag if one of column 1,2,3,4,5,6,7 isn't checked. I have tried using the IF and OR formula together but am getting #Unparseable.
Any ideas/help will be appreciated.
Thanks
Hi bukolatadio,
Try using something like this:
=IF(OR([Column1]@row = 0, [Column2]@row = 0, [Column3]@row = 0, [Column4]@row = 0, [Column5]@row = 0, [Column6]@row = 0), 1, 0)
Thanks Alejandra, will try this and let you know how it goes.
Thanks Alejandra,
I have had to add some other conditions to this and modify it and I was able to get through.
I have one sheet that is tracking PTO where a user has entered the days off. The form allows them to enter a start and end date for their PTO and enters a single record into the sheet. I have a second sheet that I am looking to pull that data into, but there is only one record per person (column in this sheet where the…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
