-
COUNTIFS Formula to calculate the number of values in a column with multiple values and parent rows
Hello, I'm trying to help a colleague set up a metrics sheet that can help them report on the number of skills they have within their department. There's a sheet of all the people in the department, which has a record of the person, their skills and what they are booked to work on. • Each of the people records are assigned…
-
Find the number in a second sheet and search for the latest date
Hey community, I have to sheets: In sheet 1, I will show the latest date for a special "string". This date I need to search in sheet 2. See picture below. In sheet 1: For the number 43KA123456 it gives me back the latest date from sheet 2 for that number. If the number is not found, it gives me back "not found". Sheet 1…
-
SUM IF Formula
I need to write a SUM IF formula that will pull a sum of the Federal Share for each project type.
-
Counting weekly entries from a Created By field
I am looking to count all the entries from a Created By field in Sheet 1 and deposit that count into a Sheet 2 that contains rows for each week of the year 1-53. The intended use is to show week over week counts of inquiries. Will eventually want to specify the count per support type for each column on Sheet 2 (Sales,…
-
Looking to create a formula that automatically counts X of X and returns appropriate values.s
I currently have a formula that counts how many matching cells in a column there are. The cells are a combination of numbers and letters. For example: CA0059 or CD0101. My current formula only counts the matching number, so for example is CA0059 shows up in 4 different cells it will count it 4 times. My current Formula :…
-
Using Index Match with Parent Children
Hello I have a grid that is currently pulling the next due date from the table from the Parent/Child combo after an action is closed. I'm trying to put together an Index/Match based on that Due date and another Column in the sheet. I want to pull the action type on the same line as the next due date but am struggling in my…
-
SmartSheet Filter Issue - Please Help!
Hello all, I've run into an issue where one of my users added a filter called "Filter" to a sheet that has caused an issue. I'm looking for some help. When the filter is ON, the sheet has 900 rows full of data. When I turn the filter OFF, the sheet only displays 10 rows of data. I have included a screenshot of the filter's…
-
Check box formula help!
I am wanting to set up a formula and/or conditional formatting so that when you check one box, it automatically un-checks another. example: two columns side by side. one titled "job started" the other titled "job done." I want it so as soon as you check the box for job done, it removes the check from job started. This…
-
Name different weeks by IF(AND Formula and WEEKNUMBER.
Hello! I need some help to make my simple formula more efective! What I want is according to my [Start Date] know the week number, and depending on that number have another column saying if it's the current week, past 1 week, past 2 weeks, and past 3 weeks. So my formula is this one =IF([Week Number]@row =…
-
Flag duplicate titles but not if the title is blank
Hiya, I am trying to write a formula that flags entries if the content of the title column is repeated, but I need it to ignore entries that have a blank title. My current one is: =IF(COUNTIFS([Conference Title]:[Conference Title], [Conference Title]@row > 1, [Conference Title]:[Conference Title], [Conference Title]@row) =…