-
Calculating costs for a task over more than one month
I'm trying to come up with a formula to calculate the labor costs per month in one sheet ( 12 columns, one for each month), by referencing another sheet, and referring to the start/finish columns of said task. E.g. Task 1: Start = Aug 27, Finish = Sept 5. So in my cost sheet, the formula needs to refer to the start date…
-
Using IFS statement with date and check box
The simple statement is I want to have a sum of work hours in a department, that is still incomplete, during a calendar period. Currently the formula is: =SUMIFS([Work Hours]:[Work Hours], Department:Department, "Wire", Finish:Finish, >=DATE(2020, 9, 1), Finish:Finish, <=DATE(2020, 9, 30)) * 8 A suggested version has been…
-
With COUNTM I can determine multiple selections are made, how can I extract the specifc selections?
If I have a multiple selection column, like 'assigned to', where I can select some or all of the people, can I determine which specific people from the list have been selected (without using FIND or CONTAINS and looking for names one at time?
-
How do I write a formula that only finds unique or duplicate text from a single column?
I have a sheet with 7,195 rows of data. I'm trying to write a formula that looks in the "Full Name" column to find which names are unique and which are duplicates. Any suggestions? I've tried this formula: =IF(Countif([Full Name]1:[Full Name]7195, 1) I also thought using the DISTINCT function may help, but I'm not sure.
-
Auto Checkbox
I would like a formula to check a box for open cases. I have a start date column and an end date column. Only check the box when there is a start date and no end date entered. Thank you!
-
IF formula for previous date
I see a lot of "countifs" solving this which is great except I need a straight IF formula.... I am trying and failing to come up with a formula that tells me if something occurred the month previous. For Example: IF [Occurrence Date] was previous month, "Previous Month", ""
-
Summarizing a Report by value count in a table
I created a report combining several different sheets, and I am trying to create (anywhere) a table that can count each topic from that combined report. Id like the table to keep updating as new topics are added. For example: Respiratory System | 1 Endocrine Systems | 1 Behavioral Health | 5 Thank you!!
-
Can I change the text in one column if the box is checked in another column?
For example: Id like to change 'Status' column to "Completed" if the 'Published' column box is checked?
-
COUNTIF CREATED SYSTEM COLUMN
can someone please assist with this? i am trying to count # of days in the created date system column for August 17th & August 18th my formula is not working
-
Tasks due within # of days
Sorry I know this is silly but can't figure out the formula looking at examples. I want a value returned if 'target end date' is due with 7, 15, 30. I have this working but can't seem to figure out how to add the additional criteria to include the other values. The values I want to return are just looking at Target End…