Community

1

Good Afternoon,

I am new to dashboards. I am trying to use an existing Smartsheet with data and would like the dashboard to display a count of how many individuals are listed in column 1 on the sheet. Is this possible and if yes, how do I set it up? Do I have to have the count built into the sheet

1

One of my managers would like to use my charts I make with Smartsheet on his report. He makes these reports with word, and would like to copy and paste specific charts into his document. Right now, our only solution is to use the snipping tool, but that isn't very clean. I know I can print my charts

7

Hello all,

I am trying to set a formula up that adds the sum of several Parent lines, but only if they are positive.  Adding all parents under one banner i use the Sum(Children) however, I tried to add only positive parents by using a SumIf(Cell1:Cell5, >0, Cell1:Cell5) but in doing so only managed

6

Hi guys!

 

I have to calculate average in my sheet and I will use: SUMIF / COUNTIF

- COUNTIF formula is working. 

- SUMIF formula is not working, i am getting #INVALID OPERATION

The SUMIF formula is (screenshot attached) =SUMIF([Assigned to in Region]8:[Assigned to in Region]136, "Sarah Mabiletsa",