-
Multiple IF to get change in progress of Status
Hi, I want my Live Status column to change as the stage progress, For ex; if my Status LO is complete my live status column should get status change to "LO Complete" and when Status LO Lock (LDS R1) changes to "Complete" the live status should change to " LO Lock(LDS R1) Complete" and so on
-
how do I add a calendar view in a Dashboard?
Hello - I have searched the community and have found a "work-around", but it doesn't work. I am trying to show a calendar view of a clients project on a client dashboard. I only want them to be able to see it. I don't want them to have any any interaction, just see it as a reference. Is this possible? Thank you. Jef
-
Smartsheets issue with Start and End TIMES - is there a way to utilize MS project to feed that info?
Hi! I have been using Smartsheets for the past 4 years, and I love this product; however, one downfall is there is no ability to have an auto updated Start and End TIMES down to the minute (not dates) based on predecessor. On my past project, this was no big deal; however, on my new project, I have been asked to track down…
-
Send automatic reminder Notification on 1st Day of every month
I see lots of posts on end of month, but can't find what I need, which I thought would be a common request. I have a column with the Status of Action Items e.g. Open, Closed, Returned, Not Started etc. On the first day of every month I want to automatically send a reminder Notification to all owners of Open and Returned…
-
Using RYG to determine health status of progress made
This is a question I am piggy backing on.. Automating a Roll up for RYG Symbols for Health — Smartsheet Community I am also trying to use a similar formula but based on % Scheduled Elapsed, % Progress delayed and % completed. I'm using a template created but trying to make a new workspace that does pull from a different…
-
Resource Management Question
Hello, Using the PMO SmartSheet template, I have created a PMO to organize all of our Information Technology projects. It is working well and rolling up to the Portfolio Level. What I am struggling with and need advise on is my IT team has a lot of little projects that they can complete in 1-2 weeks and usually requires…
-
Formula help with SUMIFS. Would like to incorporate an IFMAX in there somehow.
Here's the headers in one sheet and a few example rows to picture what I'm looking to do. So project 8 for example might see his engagement go up from Facture (invoice) 9.6 to 9.7. The engagement of PO ending in 1258 went from 888888 to 999999. That's a scenario that might happen which I'm trying to capture in a formula.…
-
Reporting Earned Value vs Planned Value for SPI Metrics
Good afternoon everyone, I'm new to the SmartSheet community, but my company and I have been integrating SS into our PM work processes for about 1.5 years. We're a VOSB DOD contractor, and we use SS to create simple project schedules that include start/end dates, duration, dependencies, and % complete. We do not resource…
-
Formula Help
Hi - I am trying to create a formula that shows the conditions of: Tasks due within the next 14 days that are not equal to the status of "Complete" or "not Required" I am looking to do this on as a summary total on the project sheet. Thank you for the help!
-
Assistance Needed with Updating Month-Wise Data and Dashboard in Project Management
Hello everyone! I've recently taken over a project that was previously managed by someone else. I've observed an issue in the project's dashboard where the month-wise data, used for generating graphs, is only available until May (please refer to the attached image). Upon inquiry, I learned that the sheet containing the…