-
pdf and excel files into multiple sheets via Gantt?
Hi there, trying to make a production line more efficient and I need to attach a file to each order (each order is a separate row). We run off of multiple sheets, and have reports broken down to each department. For example: Main Sheet: Gantt Production - includes all orders (which are linked to multiple reports) Report:…
-
Custom Template changes
Hello, I have a custom template and data is filled out for many tasks relating to employees and their progress. When I add a new task or requirement, it does not transfer to all existing sheets that have the same template applied. I have to retype the additions in each sheet for each employee. Is there a way for my changes…
-
Getting Status of Children to roll up to Parent Row
I have Parent tasks with Children tasks in a dropdown list column. The options for the children are: assigned, in progress, complete. would like to have the parent status display be blank if none of the children have a status selected (all are blank), display "Complete" only if all the children have a complete status,…
-
Report Builder
I have searched but can't find an answer. I am building a report and want to set 'what' as the following: "is a number does not contain - total" However the 'exclude selected items' checkbox only seems to operate for all conditions and I therefore cannot get the desired combination (I can have is not a number and does not…
-
Summing hours worked based on date criteria
I have reviewed the threads related to this but am currently getting an invalid value error when attempting to sum a column based on a date range. Here is what I have =SUMIFS({Ford Chicago Accounting Range 1}, {Ford Chicago Accounting Range 2}, @cell < DATE(2019, 16, 8)) Where Range 1 is the hours, Range 2 is the dates,…
-
Duration Vs Project Days
I have a project where the planned tasks are spread over several weeks, see attached. How is the summary % complete total calculated? Can I relate to %complete against project days? Regards Steve
-
If Statement Formula Unparseable
Anybody able to explain why the following formula is coming up as #UNPARSEABLE =IF(AND(ISBLANK([Contractor CO Submittal Date]@row), ISDATE([Company CO Response Date]@row), [Company Response]@row = "New CO to Contractor"), "Contractor Response Needed", IF(AND(ISDATE([Contractor CO Submittal Date]@row), [Contractor CO…
-
Project Time in Minutes vs Days
Has anyone tracked a project by minutes vs days? Goal of the SmartSheet project is to create a software upgrade by minutes vs days. Issue: The software upgrade typically takes 2 to 3 days. The upgrade schedule is by minutes and resources and task need to be schedule by minutes to plan the time the system will be down.
-
Forms
Hi, I understand how to create forms but I don't know how to view the data within the form. I assume this is the easy bit but I just can't find it. Any help much appreciated
-
Enhancement Request -> Transfer license & Sheets at same time
I just encountered a situation where I wanted to transfer a license and sheets at the same time, and was unable to do so without a workaround. I had to either get the person to transfer all their sheets to me, then change the license, and switch them back to the new owner, or take a license away from another user, give it…
