-
Macro Functionality
Hi, I am using SS to track projects. At the top of my SS I have a master list of tasks with sub tasks. I expand all this out to copy the whole lot and paste them back in at the bottom for my next project. SS does not allow you to simply copy the unexpanded parent row and copy all child rows. My question here is as follows.…
-
Default Card View Always Show Field Labels Caret Toggle
How can I force Card View to always show the field labels associated with data on all cards? I don't want to require users to click on the little caret symbol that toggles labels to display on each card... I want all field labels to always show on all cards all the time.
-
Modifying resource views
Good day and thanks in advance! Doing as I understand it's supposed to, when i open a resource view and select (and expand) a resource, all sheets with that resource are there and roll up to the total resource allocation for that resource. My challenge is that I have multiple earlier versions of plans I've developed, with…
-
IF/AND Formula
I am trying to create a formula for when two approval columns have 'Approved' in their dropdowns to change two other dropdown columns. When "APPROVAL Status - BOB" = "BOB - APPROVED" AND When "APPROVAL Status - JOEL" = "JOEL - APPROVED" THEN "Approved?" column will change to "Approved" AND "Issue Status" column will change…
-
Auto-hiding rows
Not sure if this is possible, but I would a row to become hidden based upon the status of a drop down. If cell is blank, nothing needs to happen. If cell is "delete" or "archive", I would like the row to become hidden. Any help would be awesome.
-
RAG Roll-up formula
Could anyone help me with a formula I'm trying to perfect. I am trying to create a formula that automatically captures RAG status for Children Rows and how this is communicated to the Parent rows. The plan is essentially structured like this (images are attached): * Project Plan Summary (Senior parent)* Main Tasks…
-
how to build an interactive dashboard
If I have a dataset looks like below: Project_ID Approval_Status P1 Approved P2 Declined P3 In approving P4 Approved is it possible to create an interactive dashboard showing the approval status of each Project ID? and Project ID put into a drop down frame on the left of the dashboard, user can select any of Project ID in…
-
Is my alert too redundant?
Did I set up this alert to be too specific? I want to have an individual notified when a row to which they are assigned to has the status change to "In Progress". I'm trying to test it now but have doubts about the "In a row where any status is In Progress" line I included. The red in the picture is where my colleague's…
-
Estimated Durations
I ma moving from Microsoft Project to Smartsheet and trying to replicate workflows that have served me well for decades. In Microsoft Project, I can indicate that a duration is a estimate by including a question mark, for example 5d?.I use this heavily as placeholders when building a plan so that I know that I need to get…
-
Pivot Sheet & formulas
HI, I've used pivot sheet to gather required information to show up in a sheet. I've attached a clip of the final result which works great except for the fact that I have formulas in some cells. When a new row is created, the formulas in the cells from above don't copy into the new cells. Can someone help me out. thanks!