Hi All,
Hi have attempted to automate some functions in a spreadsheet e.g. automated email, which is triggered with Conditional Formatting events. However, my issue is that I do not want the email to fire on each change but only when a person has made all the changes required and then click a command button "Update Roster Changes" to update changes.
Some content:
I use this spreadsheet to monitor my team's annual leave or movements. I have setup conditional formatting which formats a cell in a range bright red in the event where team members apply for leave resulting in only one team member to be left on site for a particular shift, called "Single Shift Events". These events are added together and displayed as a total.
I am attempting to trigger a notification email if, and only if, the "Single Shift Events" changes, on clicking the command button "Update Roster Changes"
My code works, but will always send the notification whether any changes have taken place or not when the "Update Roster Changes" button is clicked. I have commented out the email call option at the moment.
I would really appreciate if someone might be able to assist with or pointing me in the right direction.
Kind Regards
Hi have attempted to automate some functions in a spreadsheet e.g. automated email, which is triggered with Conditional Formatting events. However, my issue is that I do not want the email to fire on each change but only when a person has made all the changes required and then click a command button "Update Roster Changes" to update changes.
Some content:
I use this spreadsheet to monitor my team's annual leave or movements. I have setup conditional formatting which formats a cell in a range bright red in the event where team members apply for leave resulting in only one team member to be left on site for a particular shift, called "Single Shift Events". These events are added together and displayed as a total.
I am attempting to trigger a notification email if, and only if, the "Single Shift Events" changes, on clicking the command button "Update Roster Changes"
My code works, but will always send the notification whether any changes have taken place or not when the "Update Roster Changes" button is clicked. I have commented out the email call option at the moment.
I would really appreciate if someone might be able to assist with or pointing me in the right direction.
Kind Regards
