I am trying to Make one column of Required Certificates and then I have a column of tickets that are obtained. I would like to see a column that outlines the missing tickets that still need to be obtained

I was thinking:

=INDEX([Certificates Required]@row, MATCH([Certificates Obtained]@row, 0)) I just changed my columns around and now I get #NOMATCH

I dont know if it is possible


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!