Automatic 'Sold' text upon checkbox selection
Hello
Could be possible when I select checkbox, then automatically in the product box appears the text "Sold"
Thank you
[Re-Titled by Moderator]
MacBook Air 13″, macOS 15.1
There are several ways of doing this. My first run is a combination of XLOOKUP() to find the checkbox on the Invoice table combined with an IF() statement to check its value.
On your Products table, set cell B2 to:
=IF(XLOOKUP($A2,Invoices::Product,Invoices::Status,"",0,−1)=TRUE,"SOLD","")
This does two things. First, it runs XLOOKUP to find the value of cell A2 in the Products column in the Invoices table (denoted by Invoices::Product). When it finds a match, it returns the corresponding value from the Invoices::Status column. The rest of the XLOOKUP() parameters control how to search (exact match, top-to-bottom), and what to do if there's no match.
Since the Status column contains a checkbox, this function will return TRUE or FALSE depending on the state of the checkbox. This is simply added to an IF() statement that compares the result of the XLOOKUP. If it's TRUE, it returns the string 'SOLD', otherwise it's empty.
Just copy this formula down the column and you're done.