Choice component doesn't "lock in" dynamic (NOW calc) values once they're selected but editor does?

Hi @Jeff_Hager - using the ceiling formula you created helped lock in the values in the pull-down menu here. Hurray! I did notice that when on the hour (e.g., 4:00PM) the values did bounce back and forth between 3:59PM and 4:00PM which isn’t great because that contributes to the original problem. However, it’s not happening often enough to be concerned. I didn’t notice any odd behavior on the half hour.

Both versions of your formula performed the same. I’ll stick with the second.

Thanks again for your help with this!

snip1

1 Like