Sign in to join the conversation:
I found this discussion from 3 years ago:
https://community.smartsheet.com/discussion/adding-carriage-returnline-feed-calculated-text
It got a response from the community manager, so I would like to assume 3 years later it was implemented at some point
Is there a way I can do this?
Hi Barnee,
Yes, it is! I'll get back to the post with a link to another post.
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Here's one post.
https://community.smartsheet.com/comment/140236?utm_source=comm-notification&utm_medium=email#comment-140236
Hope that helps!
Andrée
Brilliant - a bit overkill - but it works so no complaints here!! Thank you
Excellent!
Happy to help!
@Andrée Starå adding carriage return?
Exactly what I need, but not working for me. If I understand this correctly I create a column and in the first row I enter "- (Enter) -"
When I actually press the 'Enter' key I am taken down to the next line.
Clearly I'm doing something wrong?
Hi community - ran into an issue I've never experienced before. Across all my clients, we use formulas to project dates (we've used durations/predecessors in the past, but it's not our preferred method). If we look specifically at the "TEST - SD - Internal Scope Alignment Call" line, you can see the "Start Date" formula,…
Hello. I am trying to combine contact list A with the Created By column into one Contact Helper column to use in order to restrict the user view in Dynamic View. Here is my problem. Contact List A is filled in from a form submission. The user is supposed to enter or select their email address along with the emails of any…
I'm trying to put the correct data (person) in the correct column for an Employee and their Management hierarchy, using the following formula: =IF(VLOOKUP(Worker@row, {Active Workers Report - Mgmt Lvl}, 5, false) = "Team Lead", {Manager}, "") Can someone help me correct the formula, so the Name of the Team…