Why conditional formatting doesn't show up in notification


I have an automation to send out a report every day at end of shift. recently I added a conditional format to a column that turns any cell red if its under 100% completion.

The formatting works great in the smartsheet but my problem is that once the automated email sends out, the red color does not reflect in the email.

what am I doing wrong?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!