Skip to Main Content
Status Future consideration
Categories Account settings
Created by Karla Johnson
Created on Dec 8, 2021

Inserting New Line Character in Worksheet Strings

Worksheets allow you to have formulas that concatenate strings and create a new string to display to the users. However, there is no way to include a "new line" character so that the display separates items by new line. Below is the use case we have today.

Use Case:

We created a custom table to track specific team’s activities in support of an Idea’s vetting an approval, and overall cost estimate. In the Idea level, we want to provide a summary of the costs by team (in the custom table, a team can create multiple rows each with its own cost estimate). The way we are handling this now, is in the Worksheet I am creating a row for each team and doing a sum calculation from the custom table for all rows identified for this team. Since we expect to have about 30+ teams in the organization, this worksheet will be very long. To avoid that, I am trying to only show the cost for those teams that are impacted in the custom table (typically should be 1 to 5 at the most). I can do it now in a string but it shows the information in one line and hard to read, so would be helpful if I can break it up and have one line per team. Below are images of the custom table and the summary worksheet we have so far. Note that I only include 5 of the teams so far, but expect to include many more soon.

  • Attach files
  • Nerissa Muijs
    Reply
    |
    Jun 20, 2022

    this would be ideal for us too, we're using this to display child initiatives for reporting and right now if we have many children, it's quite difficult to understand where one record ends and the next starts.