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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 443 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!