-
Build report within a specific sheet?
Hi I've been setting up a standard highlight report (sheet) and have built links from my risk, issues and exception logs. Everything is working great so far but I want to automate some additional logic. I now want to bring in a list of 'deliverables' that have been completed during a specific period and then identify any…
-
Changing the Fiscal Week from January to July (or any other month) does not affect the Timeline week
I am trying to view my Sheet in Gantt view, tracking top row by month and second row by week. This works fine, except my company's fiscal weeks are offset. I changed the settings modifying start of fiscal week to July, but the view on the Gantt didn't change. Same result using any of the other available months as start of…
-
Combining Text and Formula Into Same Cell
Hello all - I am trying to imbed a text string into a formula (using the NETDAYS() function). The end result would be something similar to: "Number of days between Kick off Meeting and Final submittal is [RESULT]". I am able to use the formula in a standalone cell with no text. In an adjacent cell, I am able to create a…
-
Alerts / Notifications not being received
Can someone help me?
-
Isolate clients from each other with one license
Hi! We are new to Smartsheet but have already encountered a potential problem. We are a management consultancy and like most of them we carry out projects together with our clients. We have one smartsheet license at the moment, and would like to keep it that way if possible. But how can we make sure each project is totally…
-
Changing the ball color on parent based on color of children
What I am trying to do is change the color of the RYG ball to red if any of the children have a red ball else leave it blank.
-
User sees only empty report sheet
Dear all I have created a report from a task list that shows only the tasks owned by a specific user. That user is not a licensed user but I shared the report with him and assigned Editor rights. When he opens the report link, he sees no entries but only the column headers. What did I miss? Any suggestions would be welcome…
-
How can I put a drop down menu that dynamically updates or adds another field?
How can I put a drop down menu that dynamically updates or adds another field? I am a Project Manager. In my Web Form I created a Project Name field that has a drop down list of current projects to choose from. After I select a project, I want another field to appear underneath it to give the end user another option to…
-
Setting date ranges with start-date to start-date and end-date to end-date dependencies
I have a project where I am setting a range of production dates and want the sheet to auto-update if I update that there is slippage in the timeline to see how far out things push. It is easy to schedule dependencies on the front end. For example - if I have items: 1. PO to readiness of raw materials is 2 weeks from the PO…
-
User form- input with dependents?
Hello, I have a project template that I would ilke to use to put a project on a master schedule. I would like to fill in this template with a form, while it adds the item to a master schedule. Can I create a form that has rows with children dependents? Thanks, Harrison