-
IFERROR not working
This seems pretty straight forward for me but it's not working. I want to add an IFERROR to this formula which is determining and displaying a status of several children steps in a process. I don't want the INVALID COLUMN VALUE to show initially as it does now, until they enter a date. I want it to be blank until they…
-
Measuring Approval Success Rate
Hi I have an approval flow that has multiple approvals. All works well and is effective. I want to start to measure the success rate against each approval stage. For example how many approval request at each stage go through first time or are declined and need more information. Is there away I can capture the number of…
-
Formulas
I have developed a large spreadsheet in which most cells are numeric and dependent on formulas in other cells in the sheet. Formulas do not auto fill when I add rows. If I delete rows, all dependent cells revert to "#Blocked" or "#Unparseable". I am somewhat new to smartsheet, so I"m guessing that I did something wrong…
-
Help for function to isolate last Modified By individual
Hello, I have a table that has two columns with the auto-generated (last) Modified and (last) Modified By data. I have created a Summary Sheet field that spits out the most recent date of modification within the sheet. I am trying to do the same for the corresponding Modified By value, ultimately to have both of these…
-
Form with formula INDEX/MATCH
Hello! I'm trying to see if this is possible. I'm creating a calibration form, but I'd like a specific task duration to be tied to each item, which then populates the due date. For example: Each piece of equipment has a set duration (ie. 365 days). This would be hidden on the form sheet. Once a user submits the form, I'd…
-
Copy and keep cell value based on day of the week.
Hello All, Is there a formula that would take a value from cell "A", copy it to cell "B", and keep that copied value in cell "B" until a set number of days have passed? Backstory: I currently have a dashboard with graphs that illustrates a rolling 7-day, 30-day, 60-day, and 90-day account interactions. I would like to…
-
Nested IF Formula - Project Health
Hello! I'm struggling to complete this formula without receiving errors. I am currently attempting to create formula in a project tracking sheet to return colored symbols (R,G,Y,G) into a "Project Health" Column. Below is the formula that I have so far. It is working up to this point, but when I try to add on IF statements…
-
Can I use @row in this formula?
=IFERROR(COUNTIFS([Expected Close Date]:[Expected Close Date], YEAR(@cell) = 2020, [Sales Stage]:[Sales Stage], "A"), "Check for 'Blanks' in Forecast, Probability or Close Date") =IFERROR(COUNTIFS([Expected Close Date]@row, YEAR(@cell) = 2020, [Sales Stage]:[Sales Stage], "A"), "Check for 'Blanks' in Forecast, Probability…
-
Issue with ABs + IF formula for RYGG Balls
Hi I am struggling with this formula. I need it to be in absolute values because the variance could be negative. I've tried a couple ways but the RYG balls just stay green no matter the negative value =IF(ISBLANK(Variance@row), "", IF(Variance@row <= ABS(5000), "Green", IF(Variance@row <= ABS(10000), "Yellow",…
-
Adding Bullet Labels in a JOIN Function
Hi! I have the Below Join function setup to summarize values from multiple cells. I would also like to add an Indicator of what information those values are representing. =JOIN([Buy Now or Trial]1:[Other Information]1, SUBSTITUTE([New Line]$1, "-", "")) Is it possible to add each cell as a bullet point? "• Buy Now or…