Combining Text and Formula Into Same Cell

Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Combining Text and Formula Into Same Cell

edited 12/09/19 in Archived 2016 Posts

Hello all - I am trying to imbed a text string into a formula (using the NETDAYS() function).  The end result would be something similar to: "Number of days between Kick off Meeting and Final submittal is [RESULT]".  I am able to use the formula in a standalone cell with no text. In an adjacent cell, I am able to create a forumla with the text string, but not using the NETDAYS() function..  How do I combine the formulas in a single cell? Thank you for your help!

Comments

  • You should be able to do that...use a something like this....

     

    ="Number of days between Kick off Meeting and Final submittal is " + NETDAYS([FirstDate]1, [SecondDate]1)

     

    Just use the plus sign as the conjunction between the text string and the formula.

     

    Good Luck

  • That worked. Thank you for the help!

This discussion has been closed.