1

I want to be able to average, or other function, over a subset of the cells in a row.  The number of cells I want to include is specifiied in a separate cell.

 

In Excel, I accomplished this with OFFSET.  I read another article here noting that smartsheet doesn't have OFFSET, but that MATCH and

1

I folks. I think I found an edge-case in your new cross-sheet formula system.

I wrote some index formulae to pull related data from other sheets when the user chose some options from a list. All was working, and I was able to link, customize and test the named ranges.  I got my two sheets converted

1

There is a great, simple comment thread feature in Google Docs and Google Sheets that I am finding very useful working with teams.  You can also do notification with a plus sign and someone's email address (+jane@abc.com) as well as task assignment to one of the people whose email address you have

2

We are experiencing issues with "links to unknown sheets" popping up.  See image attached.

  • We are saving the sheet that the link is going to as a new sheet (almost like using it as a back up), but we are clicking so that the "links do not carry over", so it should not be happening from this task.
  • We

1

I am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily accessible. I have tried reports but that only displays all of

1

I'm trying to set up a Smartsheet to track the weekly work completed for each staff member and for the overall team. We do invoice processing, which has about 20 different invoice types. We currently have a Smartsheet set up that tracks invoice types in rows. The columns track workload, which