-
Counting values
I have over 30 sheets which I store the portfolio the belong to in a sheet summary field (a drop down). I am needing a way to count these values. I am wanting to count how many schedules have the value "ETG Project Portfolio 2020" in the Portfolio summary field. thanks in advance for the help.
-
Making automatic links between sheets
Hi there, here is the workflow: User enters data into a form (done). Form populates a sheet called Master_sheet (done). One of the entries of the form is a dropdown, lefts say for example: Dog, Fish and Cat There is an sheet called Dog. If the person who completes the form chooses the Dog option, the some new entries in…
-
Contact group row notifications
Is it possible to email a contact group when updates are made to a specific row? Michael
-
Health Color Bubbles Tied to % Completion & Dates
Hellow, I am trying to take the following plan with the follow formula to follow these rules and am stuck. Disclaiming not the best at the large multi conditional formulas yet. I use the Health Column bubbles RYGB If a task has 0 % Complete and is not past Start Date, green or no health ball if possible If a task has > 0 -…
-
Formulas not processing for ages
This is a weird one, and it's been happening for some time. I have a sheet that people add to, in a batch copy and paste style. There are a few columns to the right of the batch data that process the cells and gleam certain information. It's nothing resource-intensive: e.g. in one cell we might have a person's team and…
-
How to Combine Multiple Formula for Matrix Table
Hi All, As we know, not all formula can be used in Smartsheet. Need help on combining "IF" "OR" "INDEX" & "MATCH formula. Currently we have a risk rating matrix where it depends on user selection on column "Consequences" & "Likelihood". Formula I apply in excel are:…
-
How to auto update field value in a summary sheet?
Hi, I am using a formula to caculate the "Elapsed days" in the red circle of the Summary sheet as shown below , and display this value in a Dashboard. The problem is that this value "Elapsed days" is not auto updated daily in the dashboard as i expected. What I have done is refresh the sheet then save it. After this, the…
-
Multiple criteria in a row for VLOOKUP
I am trying to create a report from data with multiple criteria in a row. The objective is to return the residual risk value for each combination of risk + strategic initiative. In Excel, I was able to accomplish what I am looking for with this formula (=VLOOKUP(CONCATENATE(D$2,"-",$B36),'FY 2020 ERM…
-
#ERROR
Does anyone know how to resolve the #ERROR? I saw previous posts saying its a problem with VLOOKUP or cross sheet formulas, but mine is on a simple formula on other columns of that same page. It was working fine all day, then suddenly updated to #ERROR. Will that go away on its own? I've tried refreshing the sheet, closing…
-
Index Join formula issue
Ok, I've been sitting on this for a couple hours and I just can't figure out what I'm missing. I have a column formula that is selectively working on certain rows, but there is no obvious difference between those rows. The formula is: =INDEX(COLLECT({APStepCode}, {SubcategoryID}, [SAP Subcategory ID]@row, {VBC ID List},…