How to use IF and IFERROR?

I am writting the formula for counting the result of the work of my team. The result is counting from the complete date< expected date would be green and if it is greater, it would be red. However, in some cases, even i did not fill in the expected date and completed date, but the result is still showed as green. This caused the confusion on the final report. Can someone please help me to delete the result which did not have the completed date and expected date? Here is my current formula: =IF([Complete Date ( TPE)]@row <= [Expected Date (TPE)]@row, "Green", "Red").

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!