-
Create range of dates for OOO
Hi, I have a list of data like the following… RowID Date Name Status 2 5/19/2025 Tom- OOO OFF 3 5/20/2025 Tom- OOO OFF 4 5/21/2025 Tom- OOO OFF 5 5/22/2025 Tom- OOO OFF 6 5/23/2025 Tom- OOO OFF 7 5/26/2025 Tom- OOO OFF 8 5/27/2025 Tom- OOO OFF 9 5/28/2025 Tom- OOO OFF 10 5/29/2025 Tom- OOO OFF 11 5/30/2025 Tom- OOO OFF 12…
-
Filter through date range between two different columns
Hello, I'm trying to use =countifs to add the number of submissions on a sheet. I've been able to populate the data when I search through one range, but I'm trying to search between two different date columns. Example: =COUNTIFS({Planned Completion Date}, AND(@cell >= DATE (2024, 10, 1), @cell <= DATE(2025, 9, 30)),…
-
Automated Alert with Attachment
I want to send a follow-up notification to a new hire once they accept a Hiring Letter or Payment Contract. We find that even if we include the attachment in the approval request, they don't download the PDF (attachment). So we want to sent a follow-up with "next steps" and another opportunity to download the PDF. However,…
-
How to extract email address from a contact list the use the value in an adjacent column
Up until now, I have copied/pasted the email address manually. Nevertheless, our database has grown so much. I've tried the below formula: =IFERROR(SUBSTITUTE(SUBSTITUTE(MID([🎓 Student]@row, FIND("<", [🎓 Student]@row) + 1, FIND(">", [🎓 Student]@row) - FIND("<", [🎓 Student]@row) - 1), "<", ""), ">", ""), "") but after…
-
Can I use the INDEX function multiple times in the same column on seperate rows?
Hello, I am trying to make a calculations sheet that will build a estimate based on input from another sheet. I have a helper reference row that actually grabs the input of a form on the origin sheet, and am using INDEX to reference the information from that row, and then multiply it by input on the same sheet. This worked…
-
Need help with cross reference sheet using SUMIF
I am trying to cross ref a sheet that has hours entered by contact list and sum the total hours kept in a seperate sheet Here is the formula i am using but getting zero in stead of 15 =SUMIF({Tot hrs}, [Assigned To:]@row, {Assigned to}) Any help will be appreciated
-
Formula looks good but getting blank return for data in the RO # field / see below
I have made a sheet referencing data from another sheet. I am having this sheet (29th street) pull the LOC (location) and RO # (Repair Order #) from another smartsheet where that data is already populated. This is the formula: The cells above and below fill in the data with no issues. Here is the reference sheet: But this…
-
Function for "current user" to use in formula?
Good morning, Is there a function of some sort that I can use in formulas that evaluates to the "currently logged in user"? Use case: I have a Sheet that that has an Assigned To column and a Consult With column, both of which are multi-select Person columns. The Sheet also has a Status column. I'd like to create a Filter…
-
Cross formula frustration
I have tried every suggestion I've found, I've used AI, and even tried things I knew wouldn't work to get this stupid formula to work. These are the column names in the target sheet. The data type is number/text, except in the date columns, and those are date types. These are the column names from the two source sheets.…
-
Check if a moratorium date falls on the range between Start Date and End Date
I have a list of moratorium dates. I want to confirm if the Start to End Date for each task range falls on a moratorium date. I used this formula and it's unparseable. =COUNTIF([Moratorium Date]:[Moratorium Date], >=[Start Date]@row) AND COUNTIF([Moratorium Date]:[Moratorium Date], <=[End Date]@row) When I test the first…