-
Project light status, Entire Row format & due date
Hi: what would be the formula for the following: project light status | Start Date | Proposed finish date | Finish date | Complete G 1/1/2015 2/10/2015 2/10/2015 complete R 15/1/2015 2/10/2015 3/15/2015 overdue/ At risk in both cases, Start date is pedecessaor to Proposed finish date and Finish date. So when we have a…
-
Is there a way to hide a completed row (% Completion Column) in a project?
Using a project smart sheet with Gantt functionality, I would like to be able to hide competed tasks in the project sheet. It is used for production scheduling so the once a task is completed it is not needed to be viewed again unless desired. Note... predecessors are used so deletion of the task is not desirable.
-
Summarizing Time sheet data
If I use a webform to collect time sheet data by employee by customer by task how can I then summarsie that data X date range X Employee x Customer x Task and visa versa.
-
Formatting With a Range of Dates
I need to create a formula that looks at two different date fields and produces the result as a check (or no check) in a checkbox field. The two columns are: "Date Requested" and "Date Received." The expectation is that the "Date Received" will be 4-6 weeks after the "Date Requested." So basically, I need the box checked…
-
what is the best way to Integrate smartsheet into an Order based Manufacturing company ?
So i have been tasked with learning the In's and Out's of smartsheet and to find the best way to utilize all of its tools for our company. we currently do the majority of our work through GP which as an accounting program is great but doesnt have the best project managment capabilities. my Question is what would be the…
-
Duration in Hours
I am testing SmartSheet in an effort to organize projects in our design and manufacturing company. Many of our projects have tasks that are less than a day in duration. We typically estimate jobs in hours. I have been testing the program using fractions for duration but when I link these tasks the program seems to allocate…
-
Change the value of a cell from the formula results of another cell
I have a RYGG, Status and % Complete columns. The RYGG has a nested IF statement that takes its values from the Status cell. I manually enter data in the Status (In Progress, At Risk, ..., Complete) and the % Complete column (10%, 25%, 37%, etc.) I would like to know if there is a way that if I enter 100% in the % Complete…
-
statistics on multi projetcs
Hello, I am working on many project and my boss want me to say which task is finish in advance, in time or late compare to the initial date calculated. ex: when the project is finished we want to know which tasks are good and which are wrong. the task drawing start the 2015 01 01 and must be finish the 2015 01 30 if the…
-
Report refreshes inaccurately
We have a report linked to one sheet at a time, used to view relevant information without the distraction of all the details. We edit in the report and save. Sometimes we will edit in the sheet and save there. We run into two issues: 1) Edits in the sheet don't always pull into the report. 2) Some text/number fields can't…
-
Power Function from Excel
I converted a power function from excel "=0.8*(POWER((9600/1000),-0.5))" and once imported it comes up as an "unexpected opperator". Is there another work around?
