<!--?xml version="1.0" encoding="UTF-8" standalone="no"?-->Hi I'm trying to track the response rates in various message threads and am having trouble writing the formula. I included a link to a sample data set as well as the sudo formula below. Any help would be GREATLY appreciated!
Data Set Link:
https://docs.google.com/spreadsheets/d/1tgocXxXtLNtIzsDQYVGleSpfjzDi73y61CFZCsKRGvM/edit?usp=sharing
Sudo Formula:
If ("Actionable" = "Y")
Then find the next row that has:
a) the next "Message #" in the sequence
AND
b) the same "thread_id"
AND
c) Sent by Other User = "N"
Then subtract the "Date" value of the second row from the first row
Data Set Link:
https://docs.google.com/spreadsheets/d/1tgocXxXtLNtIzsDQYVGleSpfjzDi73y61CFZCsKRGvM/edit?usp=sharing
Sudo Formula:
If ("Actionable" = "Y")
Then find the next row that has:
a) the next "Message #" in the sequence
AND
b) the same "thread_id"
AND
c) Sent by Other User = "N"
Then subtract the "Date" value of the second row from the first row
