Trying to Subtract two date columns with one of them having a formula
I am trying to subtract two date columns and one of the date columns have a formula referencing another sheet to pull that specific date but everytime I try to subtract the two I get #INVALIDOPERATION
Answers
-
@J21524 Can you share the specific syntax of the formula you are using? An #INVALIDOPERATION error is usually caused by operation that isn't supported by Smartsheet or something in the formula is mistyped.
Isis Taylor
🎓️ Core App and Project Management Certified 🏅
🌟Peer Connect, Mobilizer, and Early Adopter Program
Business Analyst Senior
-
So I am subtracting two columns that have dates to determine how days have passed in between
=[Date 1]@row - [Date 2]@row is the formula
But Date 1 is a column that has formula that is pulling the data from other sheet
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!