ginamt3✭✭✭

yes. I had to change the column from a multi select. It worked! thank you.

I'm just looking for the date

yep that was it! thank you.

I'm getting an error

Saturday and Sunday go to the previous Monday

Yes

Second one work! Thank you so much for your time. I really appreciate it.

Maybe this will help. So in the Dean column for this week 9/26/22 it's supposed to look at the Column Retain/Deposit and NonCash and calculate the sum of payments for that week. Does that make sense? the original formula just did it for the Retain/Deposit week. Now I need to add the noncash.

The Ret Dep column is what you want summed Yes, for the Week and specific PM The formula was working, as expected, prior to the addition of the new column: NonCash, Yes NonCash is a date column no, it's currency

I just tested. I put an amount in the NonCash and it did not update the column with the amount. no error given