-
Creating a bug burndown dashboard in Smartsheet
Hello, We are currently using the SmartSheet + JIRA connector which allows us to export JIRA stories to SSheet and have bi-directional editing capabilities of both sources of data. This works great and allows team members (like our QA team) who do not have JIRA accounts to update their SSheet and the changes are…
-
many activity logs in one place?
Hi. Does anyone know a way to see the "activity log" from many sheets in just one location? This would be like a report or a dashboard.
-
User attachments
Hi, My team members are unable to attach files under the Individual Plan. According to the Smartsheet features attached, I should have this feature on my plan. Thanks, Kyle
-
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…
