-
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…
-
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
-
Conditional Drop-down list columns
Hey Is it possible to have the the drop-down list of a column changed based on the value of another column? Eg. If column A's value is set to "Work stage 2" column B's drop-down list will have a specific list, but when it is set to "Work stage 2" column B's drop-down list changes automatically to a different list. Say…
-
Adding # of days with in a date range
this is what i came up with looking at other people i keep getting #invalid operation =SUMIFS({2021 Sioux City Utility OSHA 300 Form Range 18}, {2021 Sioux City Utility OSHA 300 Form Range 1} <= DATE(2021, 1, 31), {2021 Sioux City Utility OSHA 300 Form Range 1}, >=DATE(2021, 1, 1)) the first range (range 18) is the #number…
-
Why are the formula examples from the help section not working in practice?
Hi all, I'm fairly new with smartsheet, and I'm getting errors trying to use the direct help examples they provide for formulas. Does anyone know why, or what I'm doing wrong? I appreciate any insight!
-
(Count if) And & Or
I need a formula that will count the number of rows with High priority and are New OR Open. I cannot figure this out, so any help is appreciated!
-
Nested OR function within and AND logical statement
Hello, I am trying to have the following into a single logic statement: IF Nucleotide Category is "Labeled" AND Characterization Status is "Characterized" AND QC Status is either "Pending" OR "Incomplete" =IF(AND(Nucleotide Category]@row = "labeled", [Characterization Status]@row="Characterized", (OR([QC…