-
Counting Number of Boxes Checked in a Single Row
Hi all! I am wondering if there is a way to count the number of times a box has been checked in a single cell. For example, I have a row that shows the years that an employee participated in a program (2015-2022). You can select multiple because they can stay in this program for many years. Then I would want a formula to…
-
Need a formula to display a final test result for multiple text values
Hello, I need help with creating a formula to calculate a "final test result" for the following scenario: 1) If any cell in the row is “FAIL”, then result is “FAIL” 2) If all cells in the row are “PASS”, then result is “PASS” 3) If one cell is in the row is “N/A” or “blank”, then result is “INCOMPLETE” 4) If all cells in…
-
Count how many times a row is changed to get a percentage
Hello, My goal is to return a percentage of how many times we hit our deliver date the first time. I want to see how many times the deliver date is changed to get a percentage of how many times we hit the first deliver date we put in the field. So to do this I am having the sheet copy the row into a helper sheet and then I…
-
Index / Match with multi select criteria
I use a price calculating sheet for various criteria f.e. client or not, booking on short or long term and so on. A possible client uses a form to answer the questions and the price will be shown in another sheet "lead management" and the price will be offered to the interested people by an automation process. Is it…
-
"Incorrect Argument Set" error
The following formula works: =COUNTIFS({Sales & Leads Box}, 1, {Month created}, "June", {Year}, "2022") However, I'm getting an "Incorrect Argument Set" error when I try to add in one more criteria to this formula and not sure why: =COUNTIFS({Sales & Leads Box}, 1, {Lead Category}, "Verified Lead", {Month created}, "May",…
-
Smartsheet Formula to Click Active Checkbox in Next Row when Complete is Checked in the Row above
Title says it all but I'm putting together a workflow using hierarchy. We have certain tasks that have 6-7 phases in them before they are complete, and other tasks that only have 1 thing to do when they are complete, and I'd like to build an automated formula to check an "active" checkbox if something is a child row and…
-
COUNTIFS CONTAINS & NOT FORMULA
Hi all, I'd like to know how I can modify this formula to make it work? Within row4 to row18, I want to count the number of "Complete" deliverables under Status Column for "Product Management" under Person Accountable Column. And the count needs to exclude the deliverables with a check-off under Inapplicable Column. How I…
-
How can I link two sheets together?
Hi. I am a communications and brand manager, and I have two sheets that I will be working from primarily. One is a Request Form, the other is a Master Calendar. These need to be different because the Master Calendar includes things such as company events to which I need to send a photographer for internal communications,…
-
Nested IF, using MONTH
I feel like I am missing something simple- maybe someone else can see it? I want the formula to produce a "1" if the date in the row is January (01), February (02) or March (03). I want it to return a "2" if the date in the row is in April (04), May (05) or June(06), and so forth, to identify in which quarter of the year…
-
Can I extract the month or year from a date column for a formula...
...without creating separate columns for Month and Year like in this screenshot where formula for Verbal Agreement Month is =MONTH([Date of Verbal Agreement]@row) and formula for Verbal Agreement Year is =YEAR([Date of Verbal Agreement]@row) Thank you!