IF Statement

Amy Evans2

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

RossL

@Amy Evans2

Is the Date3 column set as a "Date" column type?

Amy Evans2

This is weird...now the formula is working. It wasn't working and I retyped several times, but now working fine.

AE

Chris Rea

https://community.smartsheet.com/discussion/comment/254655#Comment_254655

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.

Amy Evans2

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