How to combine multiple outputs

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.



Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    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