Skip to main content
Topics#Reports & DashboardsJohn Morgenthaler의 질문
John Morgenthaler 님이 #Reports & Dashboards에 질문했습니다
2020년 10월 15일 오전 2:19

Report on a field if it contains certain text

I have a an activity report where the subject either contains [Email][In] or [Email][Out]. I'm looking to get a total of each so I can compare the totals but unsure if using a summary formula in the report is the best route to do this. The only other thing I can think of is a formula checkbox on the object itself. Any suggestions is appreciated. Thanks!
답변 3개
  1. Andrew Gillan
    2020년 10월 15일 오전 3:35
    I don't think doing a contains on the subject will work in the summary field.

     

    Alternate to checkbox, just do a text formula field:

    IF(  CONTAINS(Subject, '[Email][In]'), '[Email][In]',
      IF(  CONTAINS(Subject, '[Email][Out]'), '[Email][Out]'  ,
        'Other'
      )
    )

    Then just group by the text field.

     

    regards

     

    Andrew

     

     
답변을 작성하세요...
0/9000