Function to check box if lookup is true

Options

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


Sheet2

Thanks for any assistance

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓
    Options

    You need to make sure you are creating your cross sheet references correctly.


    Type this...

    =IF(COUNTIFS(


    Then you should see a little blue link in the formula helper box that says something along the lines of "Reference another sheet". Click on that, and it will open another dialog window. Select the sheet you want to reference, then click on the appropriate column header. Once you click on "Insert Reference" in the bottom right corner of the dialog box, it will close that, go back tot he sheet you are working in, and you should see the reference now inserted into the formula right where you left off.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!