-
Using COUNTIFS to reference another sheet
I am using a count if formular to get a project count by status and incoming year. Not sure what I am doing wrong but here is my formular. Label@row references project status - in this case "Not Started". I get an output of zero but there are 10 projects with this status. =COUNTIFS({Project plan status}, Label@row,…
-
Rollup Sheet vs Report Counts Don't Match
Hi there, I have a rollup sheet with a formula to count names based on specific criteria. I need to count items that are not decommissioned, development, stating, test, Linux, numbers 7, 2003, 2008. Unfortunately, the formula does not work. To validate, I created a report filtering the same parameters. The counts between…
-
Tick a check box if conditions are met and another check box is ticked
I have 4 columns in a smartsheet Value (number), Credit Checked?(tickbox), Credit Limit(number) and Credit Limit exceeded? (tickbox) Value is manually entered Credit Checked is based on a vlookup to another sheet Credit limit is based on a vlookup to another sheet Credit limit exceeded should tick if the following…
-
INDEX MATCH with IF function
Hello smartsheet community, I am stuck! The below shows SHEET 1. There is an automation on this sheet that copies all rows on the 27th of the month to SHEET 2. I then want to pull the data from the load column back from SHEET 2, to SHEET 1. As the 'Date Added' column has a new month every month, the data will be pulled…
-
Automatically moving a duplicate row.
I am inputting data from a FORM and this creates duplicate fields. I would like to move the older row to an archival sheet. How do I move the old duplicate row?
-
I want to write an auto-workflow: copy the bottom row that is not blank from Sheet1 to Sheet2
I am using a form for users to populate a Grid. When they finish the form, the data appears in Sheet1, bottom row. When the checkbox for the row is checked/true, it triggers the workflow. The problem is the workflow copies the whole Sheet1 over to Sheet2, below the existing data, creating duplicates of the existing data in…
-
COUNTIF & IFERROR Formulas
Hey all! I'm getting a data discrepancy when I'm trying to count all of the In Progress requests that we've received in a year. The formula that I'm using is this: =COUNTIFS({Created}, IFERROR(YEAR(@cell), 0) = 2022, {Crew Support Status}, "In Progress") The Created Column uses a formula that pulls the YEAR from the…
-
COUNTIFS + OR - Forumla Help
You're all so amazingly helpful that I'm back. I think this is an easy fix for most, but I'm scratching my head. I have a column named Status with multiple drop down options, of which only one can be used. I also have a column named PMO that is a checkmark. I want to get a count of PMO flagged rows that fall within several…
-
Using COUNTIFS and OR statement
You're all so amazingly helpful that I'm back. I think this is an easy fix for most, but I'm scratching my head. I have a column named Status with multiple drop down options, of which only one can be used. I also have a column named PMO that is a checkmark. I want to get a count of PMO flagged rows that fall within several…
-
COUNTIFS Formula help in sheet summary
Hi, I currently have one field in my sheet summary which calculates the current project week. I also have one which calculates the number of tasks in the current week with the below formula, linking a column to my summary field showing the week number tasks are completed: =COUNTIFS([Projected Week Work…