-
Need to Count Distinct Based on Multiple Criteria
Hi there! I have a database (Sheet 1) where I log all my company's gifting to social media influencers and the subsequent exposure on Social Media in one sheet. I organize them by the Name of Influencer, the month we gifted, the month they posted (if they did, otherwise its blank), among others. In a different sheet (Sheet…
-
Pulling Names into Another Sheet
Hello, I am attempting to pull "In Progress" Partners into another sheet as an entire column, the purpose of this would be to create a datasheet on "In Progress Partners" who are associated to different stages of the Project. In the picture below I am pulling Partners with the right criteria, but I am hoping to create his…
-
SUMIFS Month and Year
Hi, I have this formula to sum transactions that match the month - it works well. =SUMIF({Bank Date}, MONTH(@cell) = 7, {Bank Received Amount}) - SUMIF({Bank Date}, MONTH(@cell) = 7, {Bank Expended Amount}) I want to add a second criterion to match the year as well, I get #INVLAID OPERATIONS. =SUMIFS({Bank Date},…
-
RAG Formula & Date Formula
Hi I have 3 questions that I just cannot figure out! 1). I want to auto set my RAG based on a score - I've checked the other community questions and have a formula (shown below) based on previous answers but I'm getting a #UNPARESABLE error 2). I want to set a boolean based on whether a date is more than today +7 days in…
-
HLookup work around
I'm brand new to Smartsheet and trying to figure out the best (most elegant) solution to get the result illustrated in the screenshot below. Any help/suggestions would be most appreciated. TIA
-
Use DISTINCT with COUNTIFS
Hey Guys! I am so excited to see that Smartsheet has finally introduced a formula that will compute DISTINCT(Unique) values!! So, I am trying ot develop a formula to calculate DISTINCT count using one column but with a few condition(s) i.e. IFS i.e. [Range1,Criteria1, Range2,Criteria2] Refer below a sample of that…
-
IF AND with Dates
Help! I've searched and I am stuck! I'm new to SS and I cannot get any formula to work. Here's what I'm trying to do; If the status is "In Process" and today's date is greater than 7 days from the due date = Green If the status is "In Process" and today's date is within 7 days of the due date = yellow If the status is "In…
-
Index Match Showing Incorrect Amounts - Formula when there is no information to pull
Hello! I am stuck on the INDEX MATCH pulling incorrect amounts when I reference another sheet. It will work for some cells, but not others. I am thinking since the parent sheet doesn't have all the line item costs for each store such as "Shelving" or "IT/LP", that could be the issue, but not all stores will have those…
-
IF Formula Help
Hi guys, I would like to implement the following automation process of "% Complete" -> "Status". The approach would be: IF: % Complete: 0% -> "Not Started" IF: % Complete: 0% ≤x≤ 100% -> "In Progress" IF: % Complete: 100% -> "Completed" My current IF formula does not display and consider the last 2 conditions, I honestly…
-
Count if date is in the last six months
I'm trying to refine my metrics for the number of Packages archived in the last year. This formula (which is working correctly across two sheets)... =COUNTIFS({Package Status 1}, CONTAINS("Archived", @cell), {Package Type 1}, "HWMP") + COUNTIFS({Package Status 2}, CONTAINS("Archived", @cell), {Package Type 2}, "HWMP")…