Formula yields "0", should be "12"
Not sure why this is not calculating?
It seems it doesn't like that the numbers derive from a formula as when I change the number to a value, it calculates.
Thank you!
Answers

Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony

=SUM(VALUE([Formula  Work Experience 1819]@row:[Formula  Work Experience 2122]@row))
Gives me "INVALID DATA TYPE"

I believe you would have to separate each column into its own value formula:
SUM(VALUE([Formula  Work Experience 1819]@row):VALUE([Formula  Work Experience 2122]@row))
Alternatively, you could do =VALUE([Formula  Work Experience 1819]@row)+VALUE([Formula  Work Experience 2122]@row)
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!