New Help on If/AND to amortize contract revenue
Below are my cells and formula which keeps returning INVALID:
Answers
-
Remove the opening parenthesis before [Engagement Terminates] and one of the closing parenthesis from the end. That should clear it up for you.
-
Paul,
Removing the parenthesis did not work, however, changing the criteria to the "DATE(2020,12,1) format you mentioned in your other post worked!
Thanks Paul!!
-
Happy to help! 👍️
As long as your summary fields are set to be a date type field, then referencing that SHOULD have worked instead of having to use the DATE function as your criteria. That's the whole point of referencing fields like that so you have dynamic data instead of having to manually update a formula every so often...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 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!