Legal
Discussion List
- I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show …
- 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, {…
- 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…
- 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…
- Some of our projects go on for a very long time. Each group has their own list of projects. We add status notes in the Comments. The status notes can get very long and cumbersome; however, they are ve…
- 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 p…
- I was counting for current month. However, I keep getting invalid data type. =COUNTIF({Month}, MONTH(@cell) = MONTH(TODAY()))
- 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…
- 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())), {C…