need s Appsheet database list , charts and dashboard

need help with the appsheet: 1- enter the formula in appsheet that will: a- change the color based on the status b- update the status for "good" to "need attention" to "late" depending on the date & send an email or a notification c- if a new action is sale lead is entered, a notification or email will be sent 2- allow salesmen to see only their track ( maybe not ) 3- will make a dashboard with 4 charts 4- send a weekly request for a weekly report ( templet is ready ) 5- the ability to upload files with the salesmen reply 6- a weekly report & a meeting structure report 7- ill be asking the salesmen for fill them on a weekly basis