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
Check out the Formula Handbook template!