Sign in to join the conversation:
Greetings
=IF(AND(NOT(ISBLANK({Date In Service})), {In Service Zones}, Zones1))
I'm trying to compare one column that shows install dates and one that has an actually name in it.
Is that possible?
you want to count how many have blanks for the date for service zone 1?
=countifs({Date in service column reference}, not(isblank(@cell)), {In Service Zones}, Zones1)
Something like that should work. Make sure to double check your column references to be sure they contain actually are referencing the columns. Often users will click off without realizing it, then their formulas don't work even if they are perfectly typed.
We're on an annual enterprise plan & we have SSO enabled. I have shared a sheet (with edit access) to a person in our org domain, who is not currently a member. They edited the sheet, but they still don't show up anywhere as a visitor or a provisional member (I'm the sys admin so I can see all the users.) All the…
Hi, I saw a few posts about sorting not working properly, but none of them had a solution and I'm not sure if my issue is the same. A sheet I have been using and adding and removing rows to/from over the last 6 months suddenly stopped sorting the date column in ascending order for new rows. No hierarchy or filters in…
Hello, I setup a dashboard few weeks ago and now I'm unable to make ay edits to the dashboard. I still have admin access but the edit button on the top right corner is missing.
