-
Issue (or task) list, associated with a project
How do you guys manage issues for a project? I'm wondering a way to attach (or associated) a issue (could be task) list at a project sheet level. Thanks!
-
Dynamic Data in a Drop Down List
I know you can up type in a list of values into a drop down list but can a drop down list be dynamically populated with data from another column? Can you use values in one column (column A) as input to a drop down for another column (column B) . By reading the data in column A and populating a form's drop down list in…
-
Pushing cell data to a map for plotting
Hi all, Im building a capability for an operations centre with smartsheet and was wondering of I can push cell data, such as an address to a GIS system to plot the tasks onto a map like Scribblemaps or the like?
-
Parent/Children Formulas with Date Ranges
Hello, Can I get some guidance on how to properly use Parent/Children formulas for a Summary sheet that is fed by information from a reference sheet? I have several count ifs, and sum ifs all corresponding to the month and the year. The parents and children will all have the same metrics and hierarchy for multiple…
-
Grid to Card View
Is it possible to create a project plan in Grid View and have it seamlessly transfer to the Kanban board on Card View? The hierarchy on the Grid View impacts the display of cards on card view. See attached screenshots. Ideally, I want to enter the project plan in Grid view and then have all the tasks show as cards in Card…
-
Resource contouring -> variable allocation per day or week on a single task
Hi All, we often have changing allocations for team members on a given task - ie no a flat 50% allocation for one task across multiple days. For instance - that person's allocation may be 25% the first day 50% the 2nd and third, 100% the 4th and 25% on the last day of the task. This is known as resource contouring in MS…
-
*** Times of execution of a requirements with different people assigned*****
Hi everybody, I need your help. Currently, our requirements request process is as follows, enter the form within Smartsheet register the emails of the people who want the application to send, Then these people receive and assign other resources if necessary. It is important to indicate that it is a single requirement that…
-
Saving spreadsheets in workspace
Hi all, I could not find any thread with this specific problem, pardon me if there is one.... I created a new Workspace, and within that workspace i also created a single spreadsheet. So i start writting content on that spreadsheet, then click the small "floppy" on the top left, close the page and then, when i come back,…
-
Count Multiple Cells If Multiple Conditions with Date
Hello! I am working on linking a database to a results sheet and I need several metrics pulled out. I have Supplier, Defect Column 1, Defect Column 2, Defect Column 3, and date. What I ultimately need to do is create a January through December count of defects per Supplier. So I have Jan, Feb, Mar, ... Dec. on one axis,…