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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!