-
RACI Matrix
Hi I am looking for a good RACI matrix that tracks the same way an issues and actions list works. I want to combine the two sheets into one tracking sheet and shows the RACI matrix for each issue/action. Does anyone have any good templates I can use as a boilerplate maybe? Thanks my email is constance.wade@allscripts.com
-
applying vacation or unavailable time to resources
Hello, I am an MS project user and in that program you could denote unavailable time for resources so when a task assigned to that person fell on an unavailable time period, the start and end dates accomodated for that automatically. Is there a way to do that in SS? thank you, Karen
-
Interactive Room Map
Hi all i have a room full of storage freezers. Within each freezer there are 4 shelves of four stainless steel containers. Each container contains 32 positions and each position is a project. is it possible to start with an interactive “map” of the room, where I can click on any freezer, select a shelf then a container and…
-
IF statement with flag symbol
Per the attached screen shot. How would the formula be written so that the row2 flag turns red IF any of the flags(row3-row11) are toggled to red? Thanks
-
Select multiples in either a drop down or check box on a form?
I am working on a customer survey (form) and would like the customer to be able select multiple items in a drop down or have multiple check boxes available in a single column? Is this possible now? Is this in development? I know there a couple of ways to work around this but nothing very elegant comes to mind. It's…
-
Automate RYGGrey
I need help with a formula to automate my RYGGrey. Here are the rules: If status = complete, grey If status is in progress or not started and finish is in the past, red If status is in progress or not started and finish is today + 5 days (within the next 5 days), yellow If status is in progress or not started and finish is…
-
Issue with CountIf not correctly calculating
Hello, I am using the formula =COUNTIF(CHILDREN(), 1) + "" to count the total number of checked check boxes. However, The number displayed is 0 when I can clearly see the box is checked in that column. For other columns it displays a number but not an accurate count of checked boxes within the column. Is there a different…
-
Formula returning a blank cell
I have been trying to figure this out for hours with no luck. We've created a formula to automatically update our status column in our project plan sheets. We have specific parent rows that are designated as milestones. The milestone row status cells should update based on the status of the child rows. A milestone row is…
-
T-shirt size icons for visual icons?
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team
-
Data Matrix for dashboard - cross sheet formulas
I have created extensive data matrix's to calculate # of Jobs and dollar amount for individuals in our company to track capacity. However, as our sheets get larger, the formulas wont calculate. I receive an error message reading: "Some cross-sheet formulas cant be updated, because this sheet has more cells referenced from…
