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.
Can someone tell me how to get rid of the 120.0% max on this graph? It is always going total 100% and never any more, so I would like to use more of the space for graph display purposes. I even tried reducing it so that the largest value was 99.999%, thinking maybe being exactly 100 would cause the next "level" to…
I have 2 sheets that I need to link: Sheet 1 - collects user registration information through a form. Sheet 2 - I want to link some columns to copy partial data collected in sheet 1 and have it show in sheet 2. I don't want to copy the entire row, just select columns and I don't have Smartsheet Bridge. Each sheet has a…
Currently, I have a report connected to a single sheet. This sheet contains various formulas, including cross-sheet references. When data is added to the report, the formulas will not update/work unless the sheet is refreshed. Is there any way to have the formulas values "pop-up", or otherwise load? It is somewhat…
