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
-
Is the Date3 column set as a "Date" column type?
-
This is weird...now the formula is working. It wasn't working and I retyped several times, but now working fine.
AE
-
I've found there must be some kind of bug in smartsheet that does that. I'll type in a formula and get some kind of error. save my work. exit my sheet. return to the sheet. and then all the calculations/formulas are working fine.
unfortunately I haven't been able to duplicate it so I can't report the issue to smartsheet. but it is certainly frustrating.
-
It's good to hear that I'm not the only one. I'll try that next time. Close the sheet and return.
Thanks, Chris!
Amy
Help Article Resources
Categories
Check out the Formula Handbook template!