Symbol Formula from V LookUp

Lauren Holmes
Lauren Holmes ✭✭✭
edited 04/11/24 in Formulas and Functions

Hello,


I am trying to use the symbols green and red to highlight any rows that don't have data, however it is not working as the column i am pulling from is a V look up into another sheet.


I tried if [in viability file?] = "#NO MATCH# then "Red", else "Green" which worked for the green rows, but as you can see the missing from viability tracker column instead of turning red, says "#NO MATCH".


Please help!!!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!