Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution and output:
I tried to make the formula for the 30k/60k/90k check as efficient and generalized as possible (no typing in specific thresholds), and did all the offer checks within one tool:
Used the mod() and round() functions to check each milestone and still report the correct next mileage level within the email, flexible to whichever milestone the car is approaching. Note the return carriages are embedded at the end of the first 2 formulas, so that if they don't apply to the customer you don't wind up managing extra white space in the final email:
It seems you can do all the email body setup within 1 tool, so I didn't have to go too deeply into reporting tools:
I added 8 tools to the starting file, excluding the browse tool at the end to check the results rather than actually emailing:
My Solution for sending email note to user.