-
Adding one word in front of selections in multi-select dropdown column
Anyone know of a formula that would do what I've manually done in the screenshot below? I'm trying to add one word in front of each multi-select option selected and put into a new column.
-
Counting how many cells have any of some multiple options in them per column
Hi everyone..... I'm so close but so far. I want a formula that sums how many times each cell has any of several options in them. My pseudo-code: Look at all the cells in a column. If a column's cell has A, B, or C in it or any combo of A,B or C, count it as 1. Count all the cells and tell me how many cells have either A,…
-
Index Match(Or Collect) with IF, LEFT, and LEN
I need help combining 2 formulas that currently work on their own but I need them to work together. SHEET 1 - IMPORT SHEET (Data comes in as "100h") I can do the following to get the results I want. =if([Column1@row]="",0, LEFT([Column1@row], LEN([Column1@row] - 1)) I get a 0 if Blank or the "100" without the "h" SHEET 2…
-
Can I create a column function where all tasks & subtasks under the parent display specific text?
I've reviewed =PARENT(Task@row) but it only displays the immediate Parent label. I want all children and grand children to either display "specific text" or to display the contents in the grandparent row, is this possible? =ANCESTOR didn't seem to work based on what I could find. Example "Monday" is the Grandparent.…
-
Column Formula to count (and sum) 'Waiting Days'
Hello, Can anyone suggest a way to manage this? I'd like to be able to count up time spent awaiting feedback from our client across various projects held in the same sheet. Essentially I need to be able to count the days between when a Version is sent and when Feedback is received. If Feedback is received on the same day…
-
COUNTIF(AND) FUNCTION
Hi again, I am trying to write the following formula and am not getting the answer I am looking for. My goal is to count the late items in a task sheet. This require two parameters to be met. the date is in the past the progress status is not "Complete" =COUNTIF(AND({Due Date Range}, <TODAY(), {Progress Range},…
-
Check for overlapping date ranges between sub tasks
Hi, I am looking for a formula that can check for overlapping date ranges between of the sub tasks on a project. In the screenshot below the project has several sub tasks and I need a formula that will identify any overlap between the dates on the tasks. I would like to prevent the use of references to cell numbers because…
-
Averageifs Question
Hello! I am wanting to do an averageifs statement, but it does not seem that is supported. Is there another way that I can calculate an average based off fitting two different criteria? Right now, I have this equation, which works for when just hitting the one criteria: =ROUND(AVERAGEIF({System Request}, [Ticket Type 2]1,…
-
Formula Error
Hello, I continue to encounter an incorrect argument error however the formula worked correctly with a previous entry and I cannot determine the cause. See below: Error encountered with top entry The formulas are precisely the same with the exception of references and I've checked the formula probably 20 times now and…
-
Countif not working for duplicate check in column
Has anyone been having issues with the countif formula to check for duplicates in a column? My output keeps showing zero even though there are 2 of the same numbers in one column.