-
Due Date w/Multiple Conditions
Hi Community! I'm looking for some help. I've been tasked with creating a "notice tracker". The team would like the [Due Date]@row to be some what of a dynamic date. Here is a snip of the sheet and the columns I'll be using. The sheet is fed via a form. The form has "Response Due Date" but is not required. It will only be…
-
Selecting two values from a column, for a calculation
I'm a long time lurker here - thanks for all of the other questions and answers that I've learned so much from. After trying multiple approaches, I've been unable to solve this challenge,, so looking for wise input. I have the following type of table in Smartsheet (not posting that exact screenshot for confidentiality).…
-
Formula to Change Symbols in Column Depending on Review Status
Hi all! I'm working on adding a formula to a column to populate status symbols in another column. I've attached an image of the sheet for clarity - I would like to display the symbols in the 'Director Approval Status' column, with the original dropdown selections listed in the 'Director Approval' column. Here is the…
-
Combining multiple IF(OR statements
I'm trying to combine these three functional IF(OR statements into a single working formula: =IF(OR(Webinar@row = "Session 1|Afternoon", Webinar@row = "Session 1|Evening"), "08/24/2023") =IF(OR(Webinar@row = "Session 2|Afternoon", Webinar@row = "Session 2|Evening"), "08/29/2023") =IF(OR(Webinar@row = "Session 3|Afternoon",…
-
Sheet Summary with 2 conditions including date range
Hello, I'm attempting to write a summary sheet formula that sums a number based on two conditions: 1 for entries <1/1/2021 and another column with a drop down choice of categories for only one category. Any luck writing a formula for a sum of two conditions? Should I be using SUMIF? How do I format both the conditions in…
-
Formulas Done vs Complete
With the formulas I currently have they work just fine. The small detail is that when they are not completed it says "2 of 3 Done" but when completed it says "6 of 6 Completed" (See screenshot). I know its minor but I was hoping to for a way to keep it consistent either all Done or all Complete. These are the formulas I…
-
Finding the earliest date for each vendor
I have a list of contracts that need to be audited periodically. I want to put a column into the list that will show the earliest date required to do the audit based on the vendor and contract expiration dates. In other words, if Vendor A has 10 contracts with expiration dates over the next 5 years, what is the earliest…
-
Formula to Identify difference in dropdown columns without numbers
Hello! I am working on a sheet that has three columns where two are drop downs (Current and Desired) with the following criteria: Enthusiastic Support Support Neutral Reluctant Obstruction Unknown I have for the third column labeled Gaps. In this column I am trying to find a formula that calculates the difference between…
-
Can IF(INDEX(MATCH())) return true for multiple rows?
I'm trying to develop a formula for the Booked column that will return true if the value in Date/Time is found in another sheet. That much I can do, but my problem is that the timeslots are 4 hours long so I need it to return true for the three following rows as well. For example, if the first timeslot (9:00-1:00) in the…
-
Date & Sum Formula Help
Good afternoon. I need assistance with a formula to sum a Status column (new, active, complete). In addition, I need this formula to capture the year it was completed (i.e., 2022, 2023, 2024). However, my values in the date columns are shown as (1/2/22, 1/2/23, 1/2/24). Any advice on how to do this or if it is possible?
