-
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…
-
Linking Green Health Indicator with Not Started Status
Used this ask a question feature for the first time last week and it has been a lifesaver. Here goes another one... How do I update my formula's to show the following. Not sure if I need to update both the health and status, or just the health. Show status as 'in progress' if the start date is greater than today's date…
-
Can someone assist with looking at children rows vs selecting exact cells?
Hello! Each time I change the sorting of this sheet, my formulas are changed. The formula is technically correct, the issue is that I am referencing exact cells, so when sorting it throws it off. =SUMIF([Open By Year]38:[Open By Year]43, @cell < TODAY(), [Total Units Signed For]38:[Total Units Signed For]43) - [# Open]@row…
-
How to have Percent Complete for two columns?
Hello, I'm using the “New Hire Onboarding Template” that my team has expanded on. We added another checkbox column, and I'm hoping to have it be included in the % Complete section as well. Below you'll see the current formula that “came with” the template. How could I add the “Delivered” column to be included in this? I…
-
Formula troubles.
I am trying to rewrite a formula and I need some help. It is to update a due date for recertification. The midyear criterion makes it more complex. Here are the parameters that reference other columns: the person's original certification date, and their 4 year recertification cycle. I am trying to get a column to autofill…
