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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 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!