Trying to Copy the Result of a Formula to a new Sheet to then use in a different Formula

Hannah Gray

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!

L_123

https://help.smartsheet.com/function/value

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.

Hannah Gray

Thank you! Hours of me banging my head against the wall fixed with one simple solution. Much appreciated!