search next boolean item
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?
Tagged:
0
Best Answer

@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!
Jason2
Answers

0