Send Daily Report only when data changes on underlying sheet

J Tech
J Tech ✭✭✭✭✭

How do we send a report only when there are sheet changes. At the moment report is set to a filter where modified field is today. But if nothing is changed a blank report is sent. How do we program so the report is only sent if there is data?

Regards

J Tech

If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!

Answers

  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭

    Hi J Tech,

    I think there is no condition checking option in sending a report on scheduled.

    You can send rows in sheet that changed by workflow automation.

    First, you add a helper column "Today" with checkbox type in your sheet , with formula : IF(Modified = TODAY(),1)

    Then create an alert workflow :

    • Trigger : when Modified change, or run daily
    • Condition : "Today" is checked

    Hope it works.


    Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.