Hey
I'm trying to get a tickbox to show at checked if :
- The ticket ID matches from another sheet
- The tickbox is also checked in that same sheet
=IF(AND({TicketID} = [Ticket ID]@row, {Completed} = true), true, false)
I have also tried replacing true/ false with 1/0
Thanks!