-
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?
-
SUMIF(S), AND, IF, Checkbox formula functions
Hi brainstrust, I am trying to build a resource conflict formula(s) that deliver the end results of: If a project row has overlapping dates AND has the same resource type(s) selected (different columns with check boxes) as the date-conflict project rows, return a "conflict" result. AND If a project has a resource type(s)…
-
Bring in Multiple Contacts to a Contact List Field using Index Match Functionality
The Index Match feature works well for many scenarios. Unfortunately, when it comes to bringing in more than one contact into a Contact List field type it is unable to. I would love to see an improvement in this.
-
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…