-
Sumifs Formula with a Contain
I am trying to get the sum of hours worked IF the "Office" Column = Administrative Solutions. The Office column is a multi-select dropdown. =SUMIFS({Project Intake with Form Range 1}, {Project Management Tracker- Discovery to C Range 9}, CONTAINS("Administrative Solutions", @cell")) Any help would be appreciated! Thank you!
-
Cross-Sheet SUMIFS is returning #UNPARSEABLE
Hello, I'm having an issue with a cross sheet formula. I'm trying to build a budget tracking system in two parts. It involves a top sheet with a the sum of all expenses by category and an expense log that is a running list of expenses. I tested the following SUMIFS in the expense log and it works correctly.Where it is…
-
COUNTIFS and AND
Hi there! I am trying to insert a formula that reads two columns from another sheet. I want to count the cells if one column equals the Primary column name in my new sheet and the other does NOT equal the status "Scheduling Complete". I can't figure it out! Below is what I currently have and have tried dozens of…
-
Referencing 2 ranges in another sheet
Hi all, I'm trying to use data from another sheet to get a count. I have 2 relevant columns in the reference sheet, Name and Date. I'm trying to count the number of dates for a given name in the last 30 days. Here's the formula I'm trying to use: =COUNTIF({Hiring Actuals Range 1}, ="Smith, John", {Hiring Actuals Range 2},…
-
Can I only show the year from the date in another column
I just want the year from [Completed Date] but not able to figure it out.
-
Formula for lights
Hi all, I have a sheet that contains fields for "Preparer Due Date" and "Preparer Status" and am trying to add in the following logic to a formula: Blue = completed Green = task not started or in process that are due more than 3 days away Yellow = task not started or in process that are due within the next 3 days Gray =…
-
Grouping
I have a tracker I started from a Project template which I am pulling information from into a Report and for some reason the column I want to group by does not appear as an option for grouping. What is the reason for this?
-
How do you count the number of times a drop down item is selected in multiselect column?
We have a sheet with a column that allows multiselect of the drop down options. We need to count how many times an item has been selected but HAS only works if they select just the one option and CONTAINS grabs options that happen to appear inside other options. For example: Using CONTAINS({range},"apple") with a list that…
-
Check Mark Row
Question- I have 3 check marks within a row. My goal is to figure out a way to have only one of those check marks "checked" at any given time, not multiple. So if one is checked in one column and i check another box in another column then it will remove the existing check mark in the other column. Anyone?
-
Perform operations @row then SUM together
Hello All, I am trying to right a simplified formula to do a complicated task and having difficulty. Below is the formula in question. I am trying to SUM up all volumes of some buffers that use a specific lot of 3M KCL. I also created a helper column with a factor to divide the total by based on which buffer is using the…