Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
My formula is not working, for one specific line in my task sheet. why does it not work
This is the formula, I receive Invalid in the cell
=IF(AND(MONTH([Start Date]@row) <= 1, MONTH([End Date]@row) >= 1, YEAR([Start Date]@row) <= 2025, YEAR([End Date]@row) >= 2025), 1, 0)
Best Answer
-
Maybe if you can describe what you are trying to achive, I can help to correct it.
Regards,
Soum
Please accept my answer as Solution if it helped you
Answers
-
Maybe if you can describe what you are trying to achive, I can help to correct it.
Regards,
Soum
Please accept my answer as Solution if it helped you
-
Hi,
thank you for coming back. I have received support. Problem is solved.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 449 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I hope my explanation makes sense. I currently have a basic formula that shows "networkdays" between 2 dates, however it obviously shows "invalid date type" when the "end date" has not been entered =N…
- I am struggling to get the formula right to solve this problem. My formula can count if there are duplicates in this field, but it also counts it if the field is blank (because many rows won't have a …
- Hi, I have a column that I'm trying to convert to column formula but won't because "The column formula syntax isn't quite right" and gives me Smartsheet's help article for more information. The column…