-
Formula for distinct or unique totals based on multiple criterias
I am creating a table to collect total REPORT KEYS that are unique month to month for each dept, each division and with unknown total transactions in each report key (we don't need to know how many transactions in each REPORT KEY). The data set can include up to 100 REPORT KEYS with no set amount of transactions for each.…
-
Count If and Not blank
Hey everyone, I am trying to count cells in a column where one column is not blank and cells in the other column matches a certain criteria. The columns are: Responsible Department - I want to count the cells in this column that are not blank and Program Name - Here is the Criteria - I want to count the cells in the…
-
Nested IF statement for multiple date range
Hello! I am currently attempting to write an all encompassing formula to read through different work windows. We are only able to work in certain areas of the city depending on the "work window". Depending on the work window, these dates have differing start and end dates. I can get one window to work properly, but the…
-
Make a link reference in a sheet to data in a report?
Hello, I want to link data from a report (a grouped sum amount) into a sheet with a reference link and/or add it to a formula. How can I pull data from reports to use in sheet formulas and/or rows/columns? Thank you, Angela
-
Counting Formula Help
Hi, I am looking for a formula that counts that instances that a particular department was listed. In my scenario, Person 1 & Person 2 belong to the same department. Current formula I am using is Attendances by Person 1 + Attendances by Person 2 which gives me a result of 6 however, since they are from the same department,…
-
Index Match is pulling correctly and then starts duplicating wrong values in cell
Hello, I am trying to pull in the email address from a master contact list into a different contact list with pay rates. I am using this formula: =INDEX({EMAIL}, MATCH([Full Name]@row, {FULLNAME})) and initially it is pulling the correct email address to the correct individual, then further down the page it starts…
-
AMI Estimator Formula
Hello! Has anyone set up a formula in Smartsheet to calculate the Area Media Income (AMI) Percent? I would like to enter an amount into a row and set up a formula that calculates what percentage of AMI an applicant is. I think it would be a long formula that might include all the different amounts of AMI income. Thank you…
-
Countifs with OR
I feel like I almost have it: =COUNTIFS({MMES},"0", @cell), {Disease Extent}, OR(CONTAINS("Proctitis", @cell), (CONTAINS("No disease activity", @cell) Count if the column titled MMES has "0" and the column titled Disease Extent has "Proctitis" OR has "No disease activity" HELP!
-
How to pull the top row only to sheet summary
What is the best formula to pull the top row only from the sheet I am in to the sheet summary fields?
-
Count Children Specific Year
Hi! I keep receiving the "unparsable" error when trying to Count from Children (sub rows) for a specific year. Current formula entering is =COUNT(CHILDREN([Alliance Partner(s)]@row), ([AM/PM Years Active]@row, = 2024)) Note: AM/PM Years Active column is a multi-select for the years active for those rows/subrows. Any advice…