-
Forumla not returning any results
Hi I have hit a wall with this formula. The intent is to count the number of attendees where the audiece type =Sellers AND the Status colum is Blue. The dates in am interested in are Nov 1 20201 - December 31st. I have data in my spreadsheet that matches the criteria. I have used the exact date construct in other formulas…
-
Count if checkbox is checked in each week of the year.
Hi I'd like to count a row if a checkbox is checked within a specific time frame. e.g. If Column 'Role' is "LMS" and column 'Complete' during a specific time period (e.g. week 6 of the year), count as 1. =COUNTIF(Complete:Complete, Role:Role, "LMS", Complete:Complete, "1", WeekNumber=6) I've been playing with various…
-
Need formula to extract/replace domain names from email addresses
I have a column with several hundred email addresses. The emails are in all different formats (first.last@xyz.com, first initial last name@xyz.com ... that sort of thing. I need a formula that extracts/replaces the email address with the domain only. So john.doe@xyz.com becomes xyz.com ... and jdoe@xyz.com becomes xyz.com…
-
Return most recent matched result
Hello I am trying to output the most recent "pick TM z#" result based on the most recent cage number match. In the first image, a user will manually input all carts encountered. The second image shows all carts that have been found to be "defective". The second image holds the information we would like to present to our…
-
I am trying to use contains to return another cell.
I am using the contains formula to find a row - the cell has multiple unique numbers associated with a customer, I can return 'yes' if it's true and find this, but I need to return another cell on the same row. I can't figure this out, as index match don't work unless there is a single unique number.
-
Help with Macro-like Functionality
Hi, I want to use one cell (call it A1) to accept a numerical entry from the user (a number of hours), and another cell on the same row (call it A2) to automatically update it's value to the sum of A1+A2, and then clear the entry from A1. Each time an entry is made in A1, this would trigger the event again. It appears…
-
How to Convert Dropdown text into number of days
How do I calculate & convert dropdown text (Daily, Weekly, Monthly....) where Day = 1, Week = 7..... into number of days so it can be calculated into my sheet's 'Recurrence' filed (Re attached)
-
Combining an IF / MIN Formula
I am using a COUNT IF / MIN formula to pull in the next upcoming date based on a specific name within a range, but the formula I have is not working. Here is the situation: Sheet 1: A sheet for an individual client's open cases. Sheet 2: A sheet that includes milestone dates for ALL clients. I would like the ability to…
-
COUNTIFS OR Formulas
Hi, I want to count if range 1 contains value, or if it is any time in the future, Range 1 is a restricted Date Column. It should be something like this: =COUNTIFS({Range 1}, "", >TODAY(), {Range 1} What is the correct formula? Thank you!
-
Converting a drop down single select list of dates into a date I can use with Calendar App
I am new to Smartsheets and trying to convert a single select list of dates into a format that can be used by the calendar app. I need these dates .. Tuesday, December 29, 2020 Wednesday, December 30, 2020 Thursday, December 31, 2020 Monday, January 4, 2021 to be used to enter events into the calendar app for requests to…
