-
Moved: Recover sheet
This discussion has been moved.
-
How to fix a formula for schedule health
Hello! I have a functioning formula for schedule health for my project plan but it needs some changes and I just can't manage to do it without breaking it. The criteria for the current formula is Blue – task is ‘’Complete’’ Green – task is ‘’In Progress’’ and on schedule Yellow - task is ‘’In Progress’’ and End Date is 2…
-
COUNTIFS not counting as expected
I want to create a vendor comparison chart and for that I want to show each vendor, and the number of requirements they meet, but I also have some of those requirements that are "Must haves" and so I want to show those separately. I have 2 columns that are checkboxes - one for "MUST have:" and one for "Feature - Yes/No"…
-
Help with index/collect (or maybe something else?)
Hi, I am struggling with index collect. I'm wondering if what I'm trying to do may not be possible with Smartsheet but I'm not giving up until I ask you wonderful people! I have a large Smartsheet with many columns and I'm maxed out at 381 columns, my license is only to 400 columns so while I could probably figure this out…
-
Metrics on Dashboard
While it is very convenient to use Reports to summarize multiple sheets, it doesn't translate very well on a Dashboard where there's a need for just specific metrics, like a total or average of one column. Can we request for the Metric Widget to pull Totals from from a Report when we don't want the whole report to be…
-
countifs
I have a sheet A with Client name and status, I have a sheet B with the data, I want to search every row of sheet B for the client and status of completed live or completed live missing docs. =countif({Sheet B Range 1}, [client name]1, (Sheet B Range 2), OR(@cell = "Completed - Live", @cell = "Completed - Live - Missing…
-
Auto Numbering
I want my Parent action items to automatically number PID (is a column of the specific project the parent is related to… P stands for Parent _#### project number. PID_P_#####, then i want the tasks linked to that parent to have a PID_T_##### (Same # as the parent). How is the best way to do this?
-
Option to check parent rows only
Hello, I am creating a checkbox in a column containing parent and child rows. I do not want the checkboxes for the children row to be an option. Only for the parent rows to be able to be checked. How can I action this? Any help would be appreciated.
-
How to pull the top parent to the row
I need a way to consistently pull the top-level parent to all rows below for our reports. Here's an example: In this case, all of the apples need to have "Alpha" on their row. Similarly, all of the variations of Ed, Edd, and Eddie, as well as Easy and Edison, need to have "Echo" on their row. So on and so forth. Right now,…
-
what is the best way to combine contacts from children rows into parent row?
In a contacts column, I would like to combine email addresses that are in 2 children rows into their parent row. I have a helper column that checks a box of the children rows using the formula: =IF(COUNT(ANCESTORS([Protocol ID]@row)) > 0, 1)