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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 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!