Function to check box if lookup is true

Hi

Is it a possibility where a column contains checkboxes, for a function to sit behind that that if a lookup to another sheet returns a true value, the checkbox is ticked?

Specifically for the lookup to be:

On Sheet1: If the value in col ID and the date in col Next Inspection Date appear in sheet2 (below) in the cols 'ID_user' and also col 'until' --> that the checkbox on sheet1 is ticked.


Sheet1

Sheet1.JPG


Sheet2

Sheet2.JPG

Thanks for any assistance

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!