Formula to change text

edited 12/09/19 in Formulas and Functions


How do you generate a formula to change the text within a cell. I want to have different text for different due dates such as if the due date is within 5 days, I want the "status" cell to say immediate, and if it is within 2 months, I want the status cell to say "short term", if it is within 4 months, I want the status cell to say "medium term", and if it is within 6 months, I want it to say "long term".

Also, is there a way where you can have other people add to the "latest news" section in the team portal? I don't want them to have editing rights but I want them to be able to add comments and updates to the portal.


  • L_123
    L_123 ✭✭✭✭✭✭

    it is easier to work with days in smartsheet, as there isn't a netmonth formula.


    =if(netdays(today(),DueDate@row) < = 5, "Immediate", if(netdays(today(),DueDate@row) < 62, "Short Term"

    And so on.

    As far as adding to a field, you can use a form to ask for submissions. Then use the Join formula to join them together. You can even add a system column with the date and only show submissions from a time period. Or take the last X submissions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!