-
Reporting Indicators
Hey All - I'm creating a graph in SmartSheets, and wondering if there's a way to create an indicator (line, tick-mark, etc.) that would show as part of the graph where I could mark certain changes. In this graph, I'm showing Employee Capacity vs Forecasted Time, and I want to indicate when an Employee either left/joined…
-
It's Only Blocked Until I Kick It
I have a formula that leverages some sheet summary formulas and returns a true/false to support a report filter. When I change data in the sheet the sheet summary formulas sometimes return a #BLOCKED, but it is not consistent. When it does, if I go into the formula and edit it (without actually changing anything), then the…
-
Highlighting duplicate data based on two conditions
Hi, I want to make a formula to highlight whenever to cells contain the same data on the same date. I'm working with a marketing calendar and want to find a way to highlight whenever two campaigns are planned to go out to the same country on the same date. So, if two (or more) cells contain the same date as well as the…
-
Help with an IF AND formula
I should be getting better at figuring out the punctuation on these formulas. Can someone see what I am doing wrong here? If Arch review is completed, answer is 0. If Arch Review is Pending, than answer is 8 for 2 or less servers and 16 for 3 or more servers:
-
Aggregate Status Circles w/ Formula
Hi, I have these multiple statuses across 4 projects (each project is one of the rows) within 1 program and I want to be able to incorporate a formula where I can summarize all of these to a single row with the same columns in a separate sheet to present at the program level. Formula to say: If there's at least 1 yellow…
-
Anyone let me know why this Formula is failing to work
It says INCORRECT ARGUMENT SET?? =IFERROR(VLOOKUP([Description List]1, {TGS Part No}, 3, false), 0)
-
Need to set a Workflow for two items
Anyone know how to set a formula: If Request is more than 20 days out and another field is blank? I have this for the 20 days, not sure how to get the other part. =IF([Date Requested]@row < TODAY() + 20, true, false) This will be in a Check Box that looks at the Request Date (system generated) and the Start Date (populated…
-
Trying to JOIN/COLLECT across several multi-select columns in a different sheet
I've spent a fair bit of time trying to figure this out with no luck. I suspect at least part of it can't be done with multi-select columns but I'm sure some of you good people can school me on this. I'm trying to join the values of 6 multi-select columns on one sheet into a single column on a separate sheet. Cells can be…
-
Perpetually Tracking Annual Completion
We have a Smartsheet that lists out all of our renewal obligations. The PO RENEWAL DATE tells us when the obligation renews. This can change depending on the term for each product renewal (each row). I wanted to use a checkbox to be able to mark something as complete so that my flags for past due dates don't switch on if a…
-
Parent/Child Escalation Flag Formula
Hello, Can someone tell me the formula to automatically check the parent flag if any children rows have their escalation flag checked? Thanks, smra0601