-
Stumped on a formula: multiple criteria COUNTIF
I need a COUNTIF formula pulls results for a particular status result (i.e. Complete, In Progress, etc.) for all items one level down the parent/child heirarchy from a referenced parent cell. My team has multiple projects running in parallel that need to report out their progress. I was able to give a simple update for all…
-
Non-work Weekends For Only Some Rows
Hi Smartsheet-ers, I'm looking to organize a project sheet that has some task rows that work can happen on weekends, and some task rows that the work will not happen on the weekends. We work with two staffing schedules. A portion of the staff working on the project work on weekends, while the others do not. Does anyone…
-
Automate smartsheet data
Hi all, my first post on here We use smartsheet in our business for data and daily workflow. We manage dozens of employees who are getting assigned to do offline tasks, (they are not using smart sheet), usually with a client. We use smartsheet to collaborate between the managers, and we have the data in the sheets, but I…
-
Is there a way to auto-generate an MOM (Minutes Of The Meeting) type of sheet/report from your WBS?
I'd like to know if there's anyone here who has tried generating an MOM (minutes of the meeting) directly pulled from your WBS? The intention is for PMs to prevent doing duplicate work, one is updating their WBS, then another sheet or document type for their MOM. Appreciate anyone who can share their experience and best…
-
Can't work out why I am getting an UNPARSEABLE error message please help
All I need is the correct return according to the Probability and Impact criteria in screenshot 1 into my Risk log in screenshot 2 Screenshot 1 =INDEX(COLLECT({Risk Management Matrix Range 1}, {Risk Management Matrix Range 2}, Probability@row), {Risk Management Matrix Range 3},Impact@row),1)
-
Adding a Smartsheet Form to MS Teams
Has anyone discovered a way to just add the actual form from a smartsheet to a tab in a Teams channel? I am looking for a way to have my dept. log and archive certain information that they come across in their day to day work. I felt the best way to do this was by giving them a simple form to copy paste that info into. I…
-
Hello from Jo based in Australia
Hi everyone - Looking forward to becoming an active member of this community. My career is in MedTech and new business startups, specifically in Sales Leadership/Management and Business Development. Introduced to Smartsheet 18 months and am keen to transition into PM. Looking forward to learning more and would appreciate…
-
Project Charter Template
Can someone tell me where the project charter template is located? Thank you!
-
Impact Assessment Workflow
Similar to the approval workflow, Allow admins to create a customized workflow that sends an impact assessment email to allow target users to indicate if they are impacted or not impacted on a project, request, task etc. The workflow should also allow the admins to customize the message body and also allow the user to…
-
Certified Smartsheet user on the look out
Hey friends, Anyone hiring experienced Smartsheet user, if so let me know! 😁 I've been using Smartsheet for 6 years, it's so much a part of my daily work productivity and I'd like to seek out another opportunity where I could transition my skills and background in program management into. I've gain so much knowledge and…
