Forum Discussion

amacmath's avatar
amacmath
Frequent Visitor
3 years ago

Check if a certain value exists on the same day

I have a set of data (sample below) that tracks entry of progress notes by employees into individual youth records. The 'MemberID' is a unique identifier for each youth. If an employee meets with a c...
Need Help
Thomas_Daubert's avatar
Thomas_Daubert
Icon for Helper I rankHelper I
3 years ago

Hello,

 

If the condition, TELEHEALTH is true when there is 2 raws with certain values, you can simply add all values concerned in the filter : 

FILTER(Sheet1,Sheet1[NoteType] in {"F/F2", "TELEHLTH_AV"} ),

 

Then, by using a filter on the last calculated column you will obtain the list you are looking for.

 

Let me know if it works 😉

amacmath's avatar
amacmath
Frequent Visitor
3 years ago

So would I do, 

FILTER(Sheet1,Sheet1[NoteType] in {"F/F2", "CFT/2", "CFTAnRev", "TELEHLTH_AV"} ),

 or 

FILTER(Sheet1,Sheet1[NoteType] in {"F/F2", "TELEHLTH_AV"},FILTER(Sheet1,Sheet1[NoteType] in {"CFT/2", "TELEHLTH_AV"},FILTER(Sheet1,Sheet1[NoteType] in {"CFTAnRev", "TELEHLTH_AV"} )

I need it to return "TELEHEALTH" if there are any of those three note types (F/F2, CFT/2, CFTAnRev) PLUS a TELEHLTH_AV note on the same day. 

  • Thomas_Daubert's avatar
    Thomas_Daubert
    Icon for Helper I rankHelper I
    3 years ago

    First one, 

    FILTER(Sheet1,Sheet1[NoteType] in {"F/F2", "CFT/2", "CFTAnRev", "TELEHLTH_AV"} ),