Set checkbox color based on the color from another sheet


Source Sheet: JOB TRACKING

Reference Sheet: JOB NOTES

{JOB NOTES Range 1} is the SALES ORDER column on reference sheet

Unique identifier: SALES ORDER

I'd like to check the Shipped box in the JOB TRACKING sheet by line if the SALES ORDER color in the JOB NOTES sheet is green.

I'm stuck here:

=IF(INDEX({JOB NOTES Range 1}, MATCH([SALES ORDER]@row, {JOB NOTES Range 1}, 0)) = "Green",1,0)

The formula doesn't error, but doesn't work either. All my cells are 0.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!