kari1282’s Profile

Community member since January 2019

points
127

1

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

4

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