How to combine multiple outputs

Apex Predator

Hi All,

I have two conditions in my automation that generate two different outputs. Now my question is: how can I combine these two outputs and send them over a single mail instead of sending two different mails? Please refer to the below image for a clear understanding.

Genevieve P.

Hey @Apex Predator

The way I would personally do this is to set up a formula in a helper Checkbox column in the sheet - this will check the box for the row if it meets either of your criteria, then you can use this as the Condition Block!

For example:

=IF(OR(AND(NOT(ISDATE(RevisedDate@row)), EndDate@row >= TODAY(), EndDate@row <= TODAY(20)), AND(RevisedDate@row >= TODAY(), RevisedDate@row <= TODAY(20))), 1, 0)

Cheers,

Genevieve