-
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},…
-
Row Copying Issue
Hi I have a sheet, and in it there's a VLOOKUP to another sheet. I set a Copy Row Automation so that when the vlookup cell is filled, it should Copy the Row. I setup the Wrokflow like this: Trigger: When a Row is Changed When: <Field> Changes to Any Value Run Workflow When Triggered So, everything pulled into the sheet…
-
Check Box function not working
For some reason today I am unable to get a check box to work in a new sheet or even add one to an existing sheet.If I create a column and select "Check box" in the column properties, the empty check box doesn't appear. If I add a "1" to the cell then the "checked" check box appears.Any sheets I have with existing check…
-
Formula Issue with Symbols
Hi I used to be able to create a formula for a column that had a symbol that would automatically populate for example if Level="Milestone", "Yes","No" and this would automatically put a Star in the place where the task was shown as a milestone. This now only shows the word yes. I have deleted the formula and then converted…
