Ive tried a few different scripts on how to auto sort by date but i can't seem to find one that works or maybe there is an underlying issue, i want to sort my sheet by expiration date so soonest date is at top but also so i can continue to add rows down the page as needed for new clients. The contract expiration is calculated through a formula as well "start date "C" + total weeks "K" = Contract expiration" formula i used is this " =C4+(7*K4) " just wanted to leave this info in case it affects the auto-sorting.
https://gyazo.com/798e3cba83c322192f16555ab18f7058
Problem 2, i have a second sheet where i track clients as they check in, what im trying to achieve is when i enter a clients name in "B" and day of week check in day "M" clients name goes to page 2 Formula im using " =IF('Client & Contact'!M4:M153="Monday",'Client & Contact'!B4:B153) " the issue i run into on tab 2: Client 1 goes to row 1 , client 3 goes to row 7 with row 6 being blank.
https://gyazo.com/02467b5acfa9fb865b99c14095bdb902
Thank you for any help with this
https://gyazo.com/798e3cba83c322192f16555ab18f7058
Problem 2, i have a second sheet where i track clients as they check in, what im trying to achieve is when i enter a clients name in "B" and day of week check in day "M" clients name goes to page 2 Formula im using " =IF('Client & Contact'!M4:M153="Monday",'Client & Contact'!B4:B153) " the issue i run into on tab 2: Client 1 goes to row 1 , client 3 goes to row 7 with row 6 being blank.
https://gyazo.com/02467b5acfa9fb865b99c14095bdb902
Thank you for any help with this