IF Statement

Hello,

I have the following statement:

=IF([Team Number]26 = "yes", MONTH(Date3), 0)

Issue is that when my Team Number26 cell contains "yes", I get a zero instead of the Month(Date3).

Maybe I cannot put "Month" function embedded in the IF statement?


AE

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!