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.
Need help: We are using an approval request automation where we would like to incorporate a SharePoint link rather than a file attachment to the request. We have a sheet column with the hyperlink, but it does not show up in the approval email or it shows up as a LONG URL. Needs to function both from desktop computer as…
I am the owner of a workspace that has multiple sheets and a dashboard. There are 3 Guests with Admin permissions for the whole workspace. They can edit the sheets, but not the dashboard. Is there a different type of permissions or some kind of limitations to dashboard editing for Guests?
I am looking at trying to build a multi-select option raffle form. Lets say a form user has 5 options or "tickets" they can put into a bucket of goods for a raffle. I would like for the user to put in any combination of entering tickets per good that they can with the five tickets they have. I will put in a picture of what…
