Formula to change text
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.
Help Article Resources
Check out the Formula Handbook template!