-
Descendants vs Children
How can formulas be run against all Descendants of a Parent row, rather than only direct Descendants (Children)? Example: =SUM(DESCENDANTS()) Thank you.
-
SUMIF from cells with multiple values
I'm looking to pull a budget report that will help calculate the total of a cell if the criterion cell has multiple values. I have a formula that works in Excel, but doesn't seem to translate into Smartsheet. I think my issue is how to specify the correct value for the criterion. Does anyone know the best way to convert…
-
Gantt Chart Quarters
When I edit a SmartSheet Gantt chart to change the Start of fiscal year to October it works great . . . for me. However when other users look at it, the change does not apply. In this example, I share out sheets to users who are not licensed users, so they can not change gantt settings. How can I set my chart to be global…
-
Starting Number New Each Month
I use smartsheet as a project management operation for my office. I'm using the auto-number field to create a request number associated with the request, {YYYY}{MM}-0000. I would like the 0000 number to start from 1 each new month. Is there a way to do it other than manually entering in 1 at the end of each month?
-
Assigning a number with a formula
I am creating a PO System. When I enter the name of who is making the request I want to assign a number to this person. This is what I have so far. =IF(Request1 = "Greg", 1) When i try to add to that I get #UNPARSEABLE =IF(Request1 = "Greg", 1), IF(Request1 = "Bill", 2) what am i doing wrong?
-
Create additional dependency column to facilitate auto roll-up to parent
I created a new column "Effort". I want the "Effort" rolled up to the parent. That is not happening. One of the FAQ states that column must be a dependency column. However, I can only see "Predecessors" and "Duration", when I go to <Project Settings/Dependencies Settings> One way is to add a formula in the parent cell is,…
-
Business Resumption Plan
Does anyone currently us Smartsheet in their Business Resumption planning?
-
Word Document - Smartsheet Preview
Is there a way to preview a smartsheet that has been published within a word document. For example, say I want to include a list of contacts within a document but the contacts could change, rather than updating my contacts in the document and in my smartsheet I want to just update it in smartsheet and feed it to the…
-
Ability to modify template easily and quickly.
Having been a seasoned PM for a very long time, what enticed me towards Smartsheet is the simplicity and ease of use. Having said that, I believe it is a pain in the rear to modify a template. Currently, these are the steps I have to do to modify a template: 1. Create a new project from a template. 2. Make necessary…
-
Copying from excel 'cell' level to smartsheet cell
I need to transfer a great deal of cell level data (including sketches that have been inserted) from an excel worksheet into my smartsheet. There doesn't seem to be a paste functionality at the cell level?? Or am I missing something really obvious?! thx!