I need to determine if the same "caller" made a call within a 24 hour period (Jack Black did in the below example INC1 and INC2)
Number | Created | Caller |
INC1 | 2020-12-01 07:21:20 | Jack Black |
INC2 | 2020-12-01 09:21:20 | Jack Black |
INC3 | 2020-12-01 07:40:22 | Bob Brown |
INC4 | 2020-12-02 07:41:15 | Brian Green |
INC5 | 2020-12-02 07:50:11 | James Red |
INC6 | 2020-12-02 07:51:50 | Andrew Smith |
INC7 | 2020-12-04 08:46:37 | Andrew Smith |
Hi @bh1789
You can take advantage of the Grouping functionality in the Mult-row formula tool to do this. Have a look at the example attached.
@bh1789
Try to make it to be more general in case of multiple entries for one caller.