search next boolean item

hyudolee

Hi, I want to do like this table 

"temp2" Lineitem searches the days from now to next temp1.

 

Time	2022/1/1	2022/1/2	2022/1/3	2022/1/4	2022/1/5
temp1		☑			☑	☑
temp2	1	3	2	1	1	・・・

 

Is there any function like this?

jasonblinn

@hyudolee There is no native function that does this,  but you can achieve this one with some simple staging.

 

 

Essentially I am looking for when the next time is that X is being checked. Once I find that, I can do the math on the difference between the day and the next day that is checked. 

 

 

Hope this helps!
Jason