-
Combining multiple criteria in COUNTIFS formula
There seems to be an error in my formula. The first part works by itself (counting the number of times the SME's name appears). Then, when I add the critieria to limit the count to those whose status is "Red", I get an "incorrect argument" error. It is selecting the correct data sets to pull from. Please look at my formula…
-
Help with Collect / Match / Vlookup formula
Working on a collection of sheets that I use between the different staffing agencies that service my operation. My Sr. Ops manager publishes a sheet (with the green shaded cells in the attachments below) with the labor order (by agency) each day for up to a week at a time. I am wanting to have the agency specific sheet…
-
Formula Help: Completed Project Count for Parent Rows Only
Hello, I am new to SmartSheet, and I am trying to create a formula that adds up the total number of projects that have a check mark in a Completed column. Note: I created a row to star all of the projects in parent rows (to distinguish from tasks in the children rows). So essentially, I want to add up all of the starred…
-
Auto-Refreshing Sheets/Grids - to auto update formula cells.
I saw a post in the community at https://community.smartsheet.com/discussion/auto-refreshing-sheetsgrids which had a similar question. But no answer was provided and the last update (from another member) was in Dec. 2018. Again, no response or answer was provided. I have a sheet, with formulas, to calculate today's date,…
-
How to select a last added value from a column
Would love to get feedback on how to get a "Last added value" of a particular item. I have a list of items which keeps adding in the sheet as new rows. I need a formula that looks at a column to pull the latest value/entry made. What I want is a formula that updates automatically as I populate new rows. Below is a…
-
How to take "canceled" out of the equation
Hello! I am trying to make it so an exclamation point appears if something is past due and not complete. Here is my current formula: =IF(AND(NOT(Status7 = "Complete"), TODAY() > [End Date]7), "High") This is working great but it will have an exclamation point appear if something is past due and canceled. I would like for…
-
Update a Status Formula
Hi, I currently have the following formula for a status column: =IF([Expiry Date]78 < TODAY(), "Expired", IF([Expiry Date]78 < TODAY() + 60, "Expiring Soon", "Current")) However, I have now added a column that is a checkbox titled "Re-Training Not Required" and another checkbox column titled "Inactive" (If the checkbox is…
-
Formula return blank result
I've attempted multiple times to create a function that result in Blue, Yellow, Green, Red health and it has been unsuccessful. Here are the results that I am aiming at: On Track > "Complete" "In Progress" = Green Ahead > "Complete" = Green Ahead > "In Progress" = Blue At Risk > "Not Started" "In Progress" = Red Behind >…
-
Cross-Sheet Reference Limit
Concerning the current limit of 25,000 total cross-sheet references per sheet - is there an easy way to determine how many are currently being used on any given sheet? Thanks!
-
Updating an aggregation sheet/dashboard with weekly data
Hi all, I'm struggling to think of a way to aggregate data that changes weekly. I will try and describe as best as I can! We have a sheet that financial advisers fill in weekly (separate sheet for each adviser) to show various information as attached in the screenshot. The adviser updates this weekly every Friday, and adds…