Trying to Copy the Result of a Formula to a new Sheet to then use in a different Formula
Help! I have a series of sheets that I ultimately want to reach the end user with dates calculated. In Step 1 I calculate the number of days each task should take based on an =IF(Contains) formula. I want this number to copy to the next sheet so that I can calculate a Due Date =([helper start date]@row - days@row)
The problem is... the formula doesn't work because the number that copies form the original formula comes through like this... And therefore making my formula invalid.
Any tips on how to get this number to copy as an absolute? When I am not clicked on the cell it looks normal, but when I click into the cell I see that it has the ' ahead of it.
Thanks!
Answers
-
shouldn't need to do the text parsing listed in the article. You can wrap either the formula outputting the '5 or the reference to the '5 with value.
-
Thank you! Hours of me banging my head against the wall fixed with one simple solution. Much appreciated!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 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
Check out the Formula Handbook template!