-
RAG Status
Hello! Newbie here :) I was wondering if someone could help with a formula I'm attempting to put together to calculate a RAG symbol status for individual tasks as well as the overall project plan. Individual Tasks: If status is complete = blue If status is in progress OR not started AND end date is today = yellow If status…
-
Allow formulas in Assigned To when Resource Management is enabled
Currently, with dependencies enabled the Start, Finish, Duration fields do not accept formulas. Additionally with RM enabled (including the new Resource Heatmap), Assigned To can no longer be formula driven. Use case: when our Marketing team generates a copy of their campaign sheet, they have a number of pre-set tasks that…
-
Sorting by Grouped Status with a custom order
I'm working on a report that has the usual project status "On track, Paused, On hold, In Queue, Delayed Start" etc… I currently have a list of the project name as a line item, then grouped by applicable status. That said, when "sorting", it doesn't give me the option to see which goes at the top or at the bottom, and…
-
What's best practice for managing multiple variations for a date?
I'm working on a sheet where we need to capture several variations for each of 3 date columns (e.g., Drafted Date, Reviewed Date, Approved Date, etc.). For each of those dates, I need to capture the baseline, best case, worst case, current estimate, and actual. As you can imagine, it's a bit unwieldy visually and a little…
-
Checklist
I work at a construction company that installs windows/doors for residential homes. We currently us a checklist in our current system. The checklist is use by both installers in the field as well as office team members. Any suggestions on how I can incorporate a similar checklist in Smartsheet?
-
Deleted Rows
RIGHT NOW: Implement a pop-up warning to alert someone and verify that they want to delete a row. You do it for unlocking rows, and that's nothing compared to deleting a row. SOON: Give us a new user level with edit access but no ability to delete rows or make it impossible to delete a row if any cell in that row is locked…
-
PDF link in dashboard
It would be nice that a PDF can be dragged and posted to the dashboard. thanks!
-
Why don't I see the critical path?
Hello Community, I have predecessors and dependencies, but I don't really see a critical, summary or driving path even though I have clicked to show them. Can anyone tell me why? Thanks, Ashley
-
Add project name to update requests
I have numerous projects that all have the same work breakdown structure. If I send out request updates (via automation) the end user doesn't know which project the request is asking about. Unless I specifically state what project I am referring to in a manual update request I don't see a way to have that info included. So…
-
UTC Date Fix - Response Required
I've not been active on this site over the past 2 weeks or more, simply because I'm becoming increasingly frustrated with the limitations I'm faced with because of bugs, oversights and a lack of fundamental features. Primary for me is a fix to the UTC Server vs Local date issue. I've spent time trying to get around it with…