 kari1282’s Profile

points
127 Hi,

I'm trying to figure out the due date for a submission if the dates remaining is >0 below is the formula I came up with, however it is not working.

=IF(INDEX({Due Dates}, MATCH([Client Matter]2, {Client Matter #})), {Days Remaining}, @cell > 0)

Also, is there a way to do an Index Match or Hi,

I'm trying to write a formula that would give me the total Number of request by person, that does not include Completed or abandoned. I used the following formula and it come up as nested criteria.

=COUNTIFS({Status}, @cell <> \$[Primary Column]7, {Owner}, @cell = "Erica" + COUNTIFS({Status}, Hi I'm trying to write a formula that will show me a column for the current Month

Currently formula

=If(Month(date column)= 9, [Project]1)- This works and displays the correct cell, however I want the column to change with the month so I tried= IF(Month(date column)=Month(Today()), [Project]1), I Hi I'm trying to fill out the hours with Index/Match. It works with some but not with other. Here is the formula I'm using

=INDEX({Week 19}, MATCH(Matter2, {Matter})  (Image 1)

Image 2 - Were data is pulling from

On some it works however on other it defaults to the first one. In the 3rd Image I use I was counting for current month. However, I keep getting invalid data type.

=COUNTIF({Month}, MONTH(@cell) = I'm looking to find the the sumif of current week for a specific matter. However the matter is only listed in the parent row

=SUMIFS({Test Hours}, {Week Number}, @cell = (WEEKNUMBER(TODAY())), {Matter}, =PARENT({Matter}@row)

I keep getting an error in the Hi,

I can figure out the sumif for the current week but I would like to add another criteria. I keep getting an error could someone help assist

=SUMIFS({Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}, {Work Type}, @cell= "Budget") I have a formula that will give me the current week capacity:

=SUMIF({Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}).

However I'm not sure of the formula to capacity for the next week or the past week capacity

=SUMIF({Week Number}, @cell = (WEEKNUMBER(TODAY()) +7), {Capacity}).

I I'm looking to create a total data sheet that gives me the total spreadsheet for the current week, next week and previous week, from data from another worksheet. The problem that I have is that the dates are the column names, does anyone have any suggestions on how to accomplish this. Currently I Is it possible to have .5% as a percentage. Whenever I put .05 it rounds to 1% and .04 rounds to 0%.

Thank