-
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?
-
A Template that is more friendly way to set this up
I hope that my screenshot is helpful, but i am still using new tools in Smartsheets, but i was wondering if anyone had any idea of a way I can set up my 1x1 meetings, per supervisor in Smartsheets. So i have 3 departments, and each department has about 12 supervisors each, and those supervisors have about 12-18 employees…
-
If Column is Greater than 0 Change Health Bubble to Red
Can someone please help me with this formula. Everything is working, other than the last section of the formula (IF([B/O Quantity]@row (greater than) 0, "Red") Sorry, it won't let me put the greater than symbol in the text box. I want when the "Health" column to turn red whenever the "B/O Quantity" is greater than 0 OR…
-
Conditional formula
Hello! I'm trying to write a formula where the I account for back filled data and then data with a timestamped "Created" column date. How can I combine the following two formulas? The one for current data: =IF([Backfilled Data]@row = 0, IF(MONTH([Date Submitted]@row) = 1, " (01) January", IF(MONTH([Date Submitted]@row) =…
-
Formula to show only certain parent row names
Hello! I have figured out how to specify if a row is a parent/child row (we call them Project/Tasks). I am trying to find a formula that will automatically pull from a specific parent hierarchy. In this case, it will always be the parents that have only been indented once (rows 22, 31, and 38). Rows 32 through 37 show what…
-
Merged: Sharing contacts in different sheets
This discussion has been merged.
-
Formula for SumIF
I need the formula for the following Sum of ($ value column, in another sheet), if value of another column = jan (which is a date column in same sheet as the value) This will forumla will be in another sheet.
