-
AVE or AVERAGEIF when refrencing another sheet
I have my master sheet set up with a duration column. I've been trying to build a formula on my metrics sheet that will allow me to average the duration column based on who is assigned that purchase order. I've tried two formulas, one using AVE and the other using AVERAGEIF and both return the #UNPARSABLE error. The first…
-
Rendering Milestone on dashboard
Creating dashboards and image widgets. There is a problem with the widget pulling from the source file. An example is a dashboard displaying milestones for a project. Milestones are seen as flat parent relationships The project plan has a typical parent-child structure, but the widget does not render correctly when linked…
-
Let folders be folders!
Let at least JPEG/PDF files be uploaded to a folder without a sheet. It is assanin to have to create a sheet to add an attachment that you have to REDOWNLOAD in order to use/export. Why not just allow a folder to have a normal folder use and upload images if I can't even export the attachments off the sheet without having…
-
Can Smartsheets talk to each other?
I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who oversees the progression of an Apprenticeship Program within our organization. The process is lengthy, time specific, date sensitive, and very fluid.…
-
How to automatically remove "unmatched" datamesh results from the Target sheet?
Hi Smartsheet SMEs! In DataMesh, selecting the "Copy and Add Data" option will keep the Source and Target sheet in sync --- automatically creates new lookup values if needed. Have you devised a solution that automatically removes/deletes unmatched data --- rows in the target sheet that no longer reconciles to the Source…
-
Possible to change the Resource Allocation End date in bulk for one project.
We have a large number of resources for multiple projects. For us, it's very difficult to change the allocation when the project date has been changed. If you can work on this, we can extend the resource allocation end date in one way for all the resources in the single project, which will help us minimize our effort for…
-
Need help with an NETWORKDAYS formula to pause the day count when a Status is selected
I need help with a NETWORKDAYS formula that will count TODAY() if Escalation Completed Date is blank and pause day count if the Escalation Progress is "Phase 0: On-Hold" and the column for On-Hold Date has a date recorded (and will still count as TODAY() if blank). Current Formula I am trying after searching in the SS…
-
Bulk allocation change in one way in Resource Management
Hi Team, We have a large number of resources in multiple projects. For us, it's very difficult to change the allocation when the project date has been changed. If you can work on this we can extend the resource allocation date in one way for all the resources in the single project it will help us minimize our effort for…
-
How to cross reference dates on a master sheet and then edit those dates on different worksheet?
Total noob here. I have a master sheet with 4 critical dates in regards to completing a major project (new restaurant opening). The critical dates are subject to change as some parts of the project are subject to be delayed due to construction, permits, etc. I would like to only have to change the dates on the master…
-
Do any other companies utilize Smartsheet for Weekly/Monthly Status Reports?
We are looking to move away from Excel based 'status reports' that are emailed each week to something that is more readily accessible and easier to manage/track. At a high level, each week an employee completes a status report on the projects/tasks they are working on or have completed. Our requirements would include: Have…
