-
How to create Report/Chart/Sheet for overview of many?
We have a Sheet for every project. Every Sheet is basically a checklist. The checklists are similar but wording and order of the tasks are different. I want to create something that will bring in just the "Completed" checkbox and the Primary Column of each Sheet/checklist so that the overall status can be easily seen. How…
-
Critical path disappeared
I was updating a project gantt chart and at some point the critical path red outline disappeared (no I didn't turn it off, I checked!) What is required that this is visible? I had to break some task dependencies to get the bars to actually show real-world dates, could that be it?
-
Approval workflow with consolidated multiple rows
I am looking for assistance with a workflow that gathers approvals using multiple rows as the source. The challenge is that I'd like the approver to only receive a single email with all their required approvals. The data looks like this: Supervisor Employee Item Approve/Reject Debbie Kathy Pancakes Debbie Kathy Eggs Debbie…
-
Auto Assign Subtasks
I am trying to use the Kanban view to allow a team to see a task with sub task checklists. Is there a way to auto assign the sub tasks by who is assigned to the parent task? Darin
-
Multiple Attachment Fields on one Form?
Hello, Are you able to have multiple attachment/file upload fields on one form? I am looking to collect two different pieces of information and want to make sure both are required. I know you can upload multiple documents on the one field. Thank you!
-
Conditional Formatting not working?
Hi, all. As the attached shows, I have a rule to turn the whole row a color if the Task Name contains "S18 D1". But, only one row is colored? Am I doing something wrong? Thanks!
-
Report Widget in Dashboard
Is there a way to share the Gantt chart separately in a dashboard without showing the report? Because of the current layout, both are included in the same widget and you have to scroll to see all the information on either one. Previous discussions regarding this topic indicated that changes were pending. Is there any…
-
Reports
My company currently uses Device Magic Forms to do daily reports for people to communicate from the field to the office. We then have to take what's on those forms & re-input that information into Smartsheet to track our projects. This is a time suck on our company, so we are trying to directly have all of this on…
-
If x Then x in columns
Hello, Using drop down choices in columns, is there a way to take a column with a certain data value, & then in the following column, only certain choices appear in the drop down choices found there, out of many? Example: Entire set of Data consists of: A,B,C,1,2,3 Column 1: If you select A, only options 1 & 2 can be…
-
Create Chart Widget Using a Report (not a Sheet)
With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget). I collect weekly "submission date" data from 40+ people. I have created a report that shows when the submission is due, when it is submitted, and the number of days (plus or minus) between the two. I…