IF Statement

Amy Evans2 · 06/24/20

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 · 06/24/20

@Amy Evans2

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

Amy Evans2 · 06/24/20

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

AE

Chris Rea · 06/24/20

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 · 06/24/20

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

IF Statement

Answers

Help Article Resources

Categories