How do I create an automation
I was wondering if I could create an automation when someone updates info on one sheet and a field on anther sheet gets updated automatically? what I want is if someone updates bill paid column on Invoice Status sheet, the Bill Paid column on another sheet gets updated by itself. How do I accomplish this? common values are name of the clients (can I use approximate match since their names on different sheets are not the same format), payment amount, date in, and date out.
Thanks so much for your time and help :)
Help Article Resources
Check out the Formula Handbook template!