Skip to main content
Hamad Hassan (Alphasys) 님이 #Formulas에 질문했습니다
Create a report of Recurring Donations created in the last 7 days, where neither Received Welcome SMS or Received Welcome Email is ticked. Group by Agency

 

The report shows Contact name, RD name, RG Created date, Agency, Received Welcome SMS, Received Welcome Email

If either Received Welcome SMS, Received Welcome Email is ticked, the line will be removed from the report
답변 1개
  1. 2022년 5월 30일 오전 9:06
    Hi,

    Just create summary report and group data by using Agency field and apply the filter conditions as like below.

    Created date = 23/05/2022 AND  (Welcome_SMS__C = False OR Received_Welcome_Email__c = False)

    There is no need to create formula field.

    If this helps, Please mark it as best answer.

    ​​​​​​​Thanks!!