-
COUNTIFS Formula with CONTAINS in a specific date range only.
Hi everyone. I have a sheet with multiple columns. One column indicates the status of a survey and another column indicates the date the survey was distributed. I want to have a formula that will count the number of rows that contains "Survey Closed" in the status column but only for rows that have a specific date (1/1/24…
-
Formula with multiple answers
Hello, Is there a formula for a row that can have multiple answers? I have one column A with names, and depending on that name in column A, I want a different number to appear in column B For example If column A=Mary, return 245 or column A=James, return 548…..etc. I have 5 names with 5 different values associated with…
-
What formula can I use in the Main Sheet to bring in a Status based on the Reference sheet?
Good morning all, I have tried Index, Index-match, IF, IF Error formula's and I can't seem to get this cross reference to work but none do. Here is the breakdown: In the main sheet I want a column to auto populate 3 statuses: Not Started: when the reference sheet task columns have not been checked off In Progress: when the…
-
Formula works in one sheet but not others (cross-refs are updated)
Hi there, I have a formula in one sheet, which looks at the task and calculates the dates for each task, excluding holidays and weekends. =IFERROR(WORKDAY([Task Start Date]@row, VLOOKUP([Product Version]@row + Task@row, {ConcatProdTaskLookupDerek}, 2, false), {TechTarget Holidays Range 2}), "") I then use this same formula…
-
sumif date range, category, and total amount
Hi! I need to total up a dollar amount spent with a date range (monthly), and that matches a category name. Can anyone help with a starting point formula for me to work with? =SUMIF({Smartsheet Range 1}, "Digital Advertising", {Smartsheet Range 2}, {Smartsheet Range 3}, >=DATE(2024, 7, 31), {Smartsheet Range 3},…
-
Trying to index match a formula for multiple sheets
What's wrong with this formula? =IFERROR(INDEX({Master Pipeline Name}, MATCH([Store #]@row, {Master Pipeline Store #}, 0), INDEX({Pipeline- OPEN Stores Name}, MATCH([Store #]@row, {Pipeline- OPEN Stores #}, 0) "")
-
If Function
I need a formula to assign people to a cell based on a person assigned in another cell. For instance: If the cell is assigned to Russ, Tyler or Kirk it needs to say Lauren. If the cell is assigned to Mason, Bryan or Will then it needs to say Cynthia. Column name is "Assigned To" and the first name goes in line 2
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
SUM IF Formula
I'm struggling a bit with a SUM IF Formula and hoping you all can help. I'd like a formula to sum the total cost column of my sheet for rows 236-246 if the start date of rows 236-246 is before the start date of the formula cell row, 220 but after the row above it, 219. Thanks in advance.
-
Having problems with Date Ranges
I want to count install for each month. =COUNTIFS({Install Date5}, "Install Date", {Install Date9}, AND(@cell >= DATE(5,01,2024). @cell <= DATE(5,31,2024)))