Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for November 2016
Discussion List
Multiple dropdown list driven by previous choices
How would you set up a dropdown list that is driven by the selection in a previous list. Example: column one has ten property's to choose from, column two is a list of locations specific to the property that was chosen in column one. Chosing a different property in column one changes the list to choose from in column two.…
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…