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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!