-
Count multiple criteria in a row
I have spent hours scrolling through all the great advice in the Community, and there is not a formula that is working for me. I need to count all the Semi-Annual Update, In Progress, and Waiting on County in a column. =COUNTIF([Status Report]:[Status Report], "Semi-Annual Update") works great to count all of the…
-
Horizontal Axis Maximum Range
Does anyone know how to alter the horizontal axis range? I have a chart that is displaying percentages but the horizontal axis maximum percent is set to 120% so pieces of the project are looking as though they are not complete. I tried stretching the chart out and making it smaller, nothing works. In excel you usually have…
-
Where do replies to Update Requests to external parties go?
I've sent a series of Update Requests to external emails and I've had about 50% response rate. I have had someone check the validity of the remaining email addresses and we've found several of the email addresses are no longer valid (they don't exist) and several others are issuing Out of Office Notifications. When I have…
-
Chart Padding Still Excessive
Hello, I noticed a new enhancement (April?) explained that charts with data points as percentages (%) will no longer included excessive padding. I still seem to have excessive padding in my chart. See attached screenshots. The columns are in text/number so not sure what the issue is. Thank you.
-
Compiling Survey Results
Hello All, There's a survey we ask people to fill out so we can better provide services. There are 32 specific locations and a long list of questions. I'd like to compile all of this information into a metrics sheet, and in the end create a dashboard. By some miracle was able to tally how many times the specific location…
-
Formula percentage with additional formula for roll up percentages
I am trying to calculate a rolled up percentage of how many students have taken a test, scoring above 80% to those who have not taken the test at all. I have tried an AVG formula as a test for 5 takers, but the % is incorrect. Here is the formula I have used: =AVG([TEST 1: Establish Point to Point Connection]3:[TEST 1:…
-
cell data randomly deletes!
when resting my mouse in a cell, the content randomly deletes (with no action on my part). How can this be stopped? screen recording of deleting - notice Column Title Row 2 - disappears NO ACTON on my part.
-
case number is 03069236
Dear Tech Support, Is anyone answering tech support issues...? Regards
-
Count Checked boxes from another sheet
Hi - I've seen this question a few times, but I am still not able to get this to work. I have a Metrics page that I am rolling totals up to so I can display a donut chart of projects per GEO. This has worked, up until now, because I have a single column as a drop-down to show these metrics. =COUNTIF({Geos}, Metric9)...I…
-
Smartsheet Support
Anyone else suffering from a lack of feedback or no support reply lately?
