-
Unique filter
Can someone help me with the below formula? I am trying to count unique values within a column that also have a specific condition. =COUNTIFS, DISTINCT({CBA - Master Range 4}, {CBA - Master Range 2}, "Accepted", {CBA - Master Range 1}, =Title@row)
-
Index Match inbounce limitation?
Hi, As I known that Vlookup has a limitation that cannot reference more than 100,000 cells and cannot have more than 100 unique cross sheet references in one sheet.(https://community.smartsheet.com/discussion/68137/vlookups-in-smartsheet-are-there-limitations) Question : I have a table with 7 columns(1 for identifier/6 for…
-
Extracting multiple lists by category
Hi. I have a master sheet where each row is allocated one of four categories. I would like to extract this data into another sheet, into different columns dependent on the category (i.e. four columns for name, one per category, four columns for date, one per category). All the functions I have tried (vlookup, match/index…
-
Question on using Sumifs
I'm trying to create a sheet that will calculate the sum of a referenced sheets based on a condition. The first column of the range is "status" and I want to report only "ongoing" statuses, the second column I want to use is "hard savings or soft" and only report "hard", and I'm trying to report the sum of the values in…
-
COUNTIF statement - if there is a number greater than zero then it counts as one
I think I need to use a countif statement but I am unsure how to incorporate this formula. If there is a number in one of those cells greater than zero under the 'Service Type', 'Project ID', 'Project End Date', 'Reason for Termination' or 'Resource posted time?' columns then for that person in the PRM column it should…
-
COUNTIFS formula for criteria in two columns in another sheet not working
I am counting how many ads are live out of how many total and I'm unable to get the COUNTIFS formula to work. The cell should reference another sheet and count how many ads are live in each category. The formula I'm using is coming up unparesable even though I referenced Smartsheet's many help pages on this topic. What am…
-
Countif formula using a date range
Hi, I'm trying to count the number of rows within a specific date range and can't make this formula work: =COUNTIFS({Date to Deactivate}@row, {Date to Deactivate}@cell >= DATE(2022,04,01), @cell <= DATE(2022,04,30)) Thanks for your help!
-
Multiple IF statements
Hello, I'm trying to populate a follow-up date depending upon the status. My formula works for one criteria: =IF([Sales Status]@row="Hold for Future Follow-up", TODAY() + 90) When I try to add on another IF statement, I get an error (I have 5 IF statements to combine). Each part of the formula works perfectly on its own.…
-
COUNTIFS range formula while referencing another sheet
Hello, I am unable to figure out how to count the total number of cells that are in a certain status AND range between 31-60 days while referencing another sheet. I have used the formula below to get a total when a cell is in the "Assiged" state AND is less than 30 days and it worked. I've also provided a screenshot of the…
-
Combining Form Submission Data with Already Existing Row Data
Hello All, I'm looking for a way to combine form submission data with data that already exists in a row. For example my row has the item information for something we're trying to resell. The form goes out to the resell companies for them to make an offer. If an offer is made its populate on a separate row. Would love to…