-
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…
-
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…