-
Resource exports
Hi I'm wanting to use SS more in how we do resource planning. One thing which is quite painful is the output from the export on the resource view. What would be easier as a complimentary tab on the excel export is a more "Pivot table usable" output, for the same range so something like Date Project Resource Allocation this…
-
Sheet Schema & Report Schema Documentation
Hi, I would like to recommend the following enancement. Please could the be a way to export as an Excel or Google sheet the Sheet Schema. This should contain all the information and properties of the sheet, As per the Properties Dialog box from the Sheet menu Plus all Field: * Column Name * Column Type * List Items * Also…
-
Counting Rows
I have a list of projects divided into sections. Each section can have projects that have sub projects. When I use this formula on a section header ="Current(" +COUNT(CHILDREN()) + ")" my result looks like this: Current (24). However, the count does not include the sub tasks. How can I write the formula so that it will…
-
Archiving Workspaces
We have just started using Smartsheet to manage our IT Programme. Each project has its own Workspace. I am just investigating the best approach to archiving projects when a project has closed. We will need access to view the project information from time to time but would not want the Workspaces to clog up the current…
-
Attachments - Group Download / Report / Collective
Hello Community, We have a sheet containing a lot of attachments (photos) which we would like to collectively generate into a report, even at the bottom of the report. Is this achievable? If so, can it refer to the row it is attached? The report we generate makes no reference to there even being attachments to refer to.…
-
Tracking Meetings In Smartsheet
I'm trying to figure out the best way to make meeting agendas, minutes and action items available to the team using Smartsheets (not necessarily *a* Smartsheet). Our group has daily stand-ups, weekly status, and other meetings, most of which will require an agenda, and any of which can produce an action item list. It's not…
-
Auto changing numbers
Hello, I'm having a strange issue, where I enter a lengthy number and then when I click out of the cell where I entered it, Smartsheet has changed it to a number immediately above or below the number I entered. When I double click in the cell, it shows me the original number I entered, then changes it again when I click…
-
Creating Governance and Structure around SS Implementation
Has anyone established best practices/documentation around governance and incorporating Smartsheet into existing operations? If so, would you be willing to share anything you've developed and/or talk over the phone? Thank you, Dean
-
Counting non blank cells in a row till first non blank.
I need to count blank cells in a row, left to right, till first non blank cell. the non blank cell may contain any character/s or digits. Any suggestions? For instance this formula will work to count blank cells till it finds X in row 1, columns 1-20, but not anything else: =MATCH("x", [Column1]1:[Culumn20]1, 0) - 1
-
Maintaining a list of small department's resources
My compny is small (about 15-20 resources with limited turnover). To allow all users to work` w1ith the same list of resources as I undestand it, because contact lists are not shared, each user (or maybe just PM) would need to create (or import) a list of names/emails that would then be available to assign to tasks using…