-
Complete/Not Complete Dots Formula for multiple rows
I am wondering if there is a way to create a formula in a cell that will tell you if the following 10-30 cells say complete. For example, when working on a project if all of the tasks beneath are "Green" or marked as "Complete", is there a way to have the top cell also say "Complete" only if all of the tasks also are? Or,…
-
How do I set a formula for an entire single select drop down column?
I am pretty new to using SmartSheets and I've just figured out how to use formulas! I've been searching everywhere but I can't seem to figure out how to set a formula for an entire column. I want the formula to be automatically be applied when a new row is added (these rows are brought in via responses to a form). This…
-
If Statement on Expiration Dates
My criteria are the following If the Expiration Date Column cell is blank or greater than today+31 days = “Yes” If the Expiration Date Column cell is within 30 days = “Hold” IF the Expiration Date Column cell = today or greater than the date in the cell = “No” I tried using ISDate, Index Match, Date Only and it's not…
-
Issue pulling Countif Reference Date ISBLANK
Hello, I am running into 'Incorrect Argument' error when trying to count cells that have a blank date for Training Start column from another sheet. My formula is: =COUNTIF(ISBLANK({NED_Project_Master Range 6})) Any thoughts to what I am doing wrong?
-
Help with iferror
Hi, I have this formula that i have written. It works fine, but I am getting blank fields, when I was expecting N/A. The product line row has EBS, JDE, SAP. The TLR Scope is Financials, HR, Payroll For EBS I want values returned and N/A for the other product lines. =IFERROR(IF(AND($[Product Line]@row = "EBS", $[TLR…
-
Need Help with COUNTIFS for 3 Columns of different input types
I have 3 columns with different input types (Contact List, Multi select Dropdown, and Single Select Dropdown). I want to do a count for criteria that satisfies 3 criteria (1 for each column). I have figured out how to do it for 2 criteria but cant get it to count for 3 criteria. My code for 2 criteria is as follows:…
-
Date Conditional Formatting
Hi- Can someone please assist with how I can a conditional format setup for the below, or does this need to be a formula? Use case below: Column Services Date is a date I enter - I would like the entire row to turn yellow if it is has been 15 days from Column Services Date, and to turn entire row red if 20 days since…
-
Sheet Summary - countif
Hi there - What is the best way to do a 'count' on a drop down field located at the "summary sheet"? For example: I have a drop down field on summary sheet called "Alignment". It has drop down values such as cost reduction, revenue, risk/fraud. Each sheets has one of those alignment category. I would like to have a summary…
-
Combining IF(AND statements with Dates
Hi - I am trying to build a combined IF statement that takes a last contacted date and a last participated date and if both are true will output a status of "available". If not, it will be "not available". Separately, I can get the a formulas to work for each date, but once I combine the formulas, it fails. First date…
-
Countifs with <> Value
i am using this to count the number of the "Brand Content" from that column "CCMS Range 2" also when it is not completed. Getting #UNPArseable msg. I am new to this, not sure if i am missing any syntax. =COUNTIFS({CCMS Range 2}, <>"Brands Content",[{Ticket Status},"120 - Completed - Project Closeout") Thanks