-
Join Collect with multiple criteria
Can someone help me with this formula? It will not work for the life of me. =JOIN(COLLECT({Current Loans Range 5}, {Current Loans Range 1}, "CASA"), [{Current Loans Range 2}, "Y"]), "; ")
-
Need help with a formula
=COUNTIFS({Demand State}, [Primary Column]@row, {Investment Class}, "Grow", {Portfolio}, "P&C Claims", <=DATE(2023, 1, 1), {Demand Opened Date}, >=DATE(2023, 12, 31)) Can someone help me figure out why it's not working?
-
MAX COLLECT WITH DATES
Hello, I'm hoping someone can help me with this. I need to pull the latest date from the "Active - Time Stamp ON" column based on the DNIS being the same. Seeing the below screenshot, the first 5 rows have the same DNIS of 0012. So the date I need it to pull back is the latest date of 06/13/2022 (from row 5). I have tried…
-
Combination of CountIFS and OR
I am trying to accomplish this: Count If: If {Current Development - Initiative}, ="Concur HS4" And, If {Current Development - Hierarchy}, ="EPIC" And If either one of these columns is not Empty {Current Development - Q2'23} <> "", {Current Development - Q3'23} <> "" This is the formula I used, but it shows #Invalid…
-
Checkbox with multiple variables
I am trying to have a box check if the following are true. Print Location = Dallas and Weekday is not Tuesday or Wednesday = True OR Print Location =NYC and Weekday is not Wednesday = True =IF(AND[Print Location]@row="NYC", NOT([Day of the Week]@row = "Wednesday")), 1, IF(AND([Print Location]@row="DAL", NOT([Day of the…
-
can anybody help with this join(collect) issue?
I created a join(collect) to gatehr all the permits that match the criteria, in this case same account. The search column [permit type] is looking at a different sheet to find the right permit type. The join(collect) in column [Number_permits] is working perfectly, that column is capturing all permit numbers of the same…
-
Any solutions or workarounds to dropdown/cell-linking issues?
Hi everyone! It's a bit of a wall of text ahead, so apologies in advance and many thanks to anyone who dares read it. I’ve got a bit of a beast of a project I’m working through and I’m hoping y’all would be able to help me work out some of the pain points I’m running into. Some of them could probably be alleviated with…
-
Need a solution to move some unique IDs from one sheet to another
Hello! I have a main intake sheet for my team to manage studies. Every time a new row is added, a unique identifier (for each unique study on this main intake sheet) is created. We have at least 3 different services that are listed on the main intake sheet. Each service a study team is requesting is marked with a checkmark…
-
Check Another Sheet for Value across Multiple Columns
In Sheet 2, I am looking to search Sheet 1 for an instance of a value, that could be in one of four columns. Sheet 1 COLUMN A | COLUMN B | COLUMN C | COLUMN D | COLUMN E | ABS 123 | March | 26444 | | 43454 | ABS 456 | June | 87834 | 45003 | | ABS 789 | August | | | | ABS 000 | October | | | 36543 | There are four order…
-
Count the number of times a text value appears in a single cell (or alternatively, split the cell)
Hi Smartsheets community, I have a column of data with cells that contain text values that I need to count. For example, the cell in one of these columns may contain something like: "ABC123 - TEXT TEXT TEXT ABC008 - TEXT TEXT TEXT" The two lines of "ABC" text are separated by a carriage return. I'm trying to count how many…
