-
COUNTIFS formula issue. Help Please?
Greetings! I am trying to count the number of times a contact appears in a range on a sheet when certain conditions apply. I am trying to make this a column formula instead of a row formula so I don't have to input every individual's name into a formula for what will end up being 20 columns of counting. The range to search…
-
New to Smartsheets and Formulas
Hello! I currently have this formula in my status column =IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", "In Progress")) but I'd like to add a rule that if the finish date is < today, "Overdue". Can somebody help me complete the formula? Also, I'm looking for recommendations for training. I'm…
-
Trying to get dates to populate off formulas
Essentially, I need to have users manually enter a start date (this could be either one cell or I could dedicate a column if needed), and based on the needed duration for each tasks the start and end date columns would be generated. For the Duration column, I would like this to populate via lookup table as the durations…
-
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…