-
Publishing Gantt Chart
We have a Gantt Chart, we have many columns for various items and the standard Start/Finish/%Complete....... We don't want to share the sheet with a lot of people they don't need all those extra columns, we really just want to show them the Primary/Task Column and the the Gantt Timeline that is it. Is there a way to…
-
MS Project Budget Reports and Smartsheet
At my organization we are currently trying to transition from MS Project to Smartsheet. Currently, using MS Project we are able to use a resource pool (every resource is added based on hourly rate, etc) and we are able to generate budget reports automatically. Is this feature something that is available on Smartsheet as…
-
FORMULA - Estimated vs Actual Time
FORMULA HELP NEEDED (See Screenshot) I need help creating a formula to show: IF "Actual Time" Column is 10% more than "Estimated Time" Column, then "ERP vs ACTUAL" Column shows "DOWN" Symbol IF Not, shows "UP" Symbol. Times are entered in minutes (00.00) Thanks in advance! This is what I currently have: =IF(AND([Actual…
-
Cell Link from web form
Hi, I am trying to link the cell to other sheet, once the data is filled up from the web form. The problem I am facing is, whenever the form is submitted & the data is posted on my sheet, it is being posted below the cell which is linked to other sheet. I used the workout of providing the cell background color to white to…
-
RYGB automation with date and status
Okay first off I did not write this syntax I copied and pasted from another post. It works to a point but I need it to be a little more detailed and I cannot figure it out. Here is the syntax: =IF(Status1 = "Complete", "Blue", IF([Start Date]1 = TODAY(), "Green", IF(AND([Start Date]1 < TODAY(), Status1 = "Warning"),…
-
Turn hours (hh:mm) to numeric value (00.00)
Is there a formula to make a column with duration values like 1:30, 2:45, 3:15, etc etc (only ending in either :00, :15, :30, and :45) to 1.5, 2.75, 3.25 hours (again, only ending in .00, .25, .50, and .75, respectively)??? I am VERY new to SmartSheet so, if you could actually explain how to do stuff that would be awesome.…
-
Duration Column Doesn't SUM up Correctly
Hello, I am using smartsheet for my master project plan and I repeatedly run into one issue, my project Duration count roll up is inaccurate. I have attached a screenshot to provide a better understanding of the issue.
-
gmail group mail or distribution list doesn't work in assigned to.
Hi Smartsheet Team, We have group mail via gmail in our company. Im using it to Assigned To contact list to notify them all for any changes. But unfortunately it doesn't work. What could be the problem. Smartsheet Group does not appear in Assigned to as well.
-
Possible to create Gantt Chart in duration of "hours" for single-day projects?
Hi, I created a project smartsheet with gantt dependencies in duration of "hours" for an important project that lasts one day. I was wondering if there is a way to create a gantt chart that only displays one day but shows durations of "hours" on the x-axis instead? (The current gantt chart I see only displays 30 days…
-
Task names in Gantt are gone
I was updating my sheet yesterday and payed no attention but this morning I've noticed that all of the task names on the Gantt chart are gone and I can't seem to find a way to get them back. Any ideas? Thank you in advance!