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.
Discussion List
Adding carriage return/line feed to calculated text
I'm pretty sure I know the answer (no) but ... can I format text with a carriage return in a formula? For example ="Line1" + \n + "Line 2" where \n is whatever I need to add to get this result: Line 1 Line 2 This article did not help.…
New Line (Alt + Enter) in Formulas
Hi I have Formula for text rows: =Coulmn1 + " " + Column2 + " " + Column3 + ... Can I set up a space char as a new line (Alt + Enter)? So every cell will appear in a new line. I need this for Google Docs. Thanks!
Joining two formulas, IF and NETWORKDAYS
Hi I have the following formula but only want it to be run where my task is in a 'Not Started' status. =NETWORKDAYS(Start1, Finish9) Is there a way to run an IF statement first as part of the above formula? I have tried running an IF statment in a hidden column but can't seem to link two together. Thanks Phil
Multiple section in a dropdown list?
Hi, Is there a way to select multiple items in a dropdown list? Here is the scenario i am trying to solve for. A product roadmap project may can be related to multiple products. I currently have a dropdown list column for products and each row is project. Currently i can only select one product per project. ideally i would…
Multiple project sheet schedules or only one?
OK Community, help me out here. I keep going back and forth (and forth and back) on this issue. I think the answer is "it depends" but I'm looking for feedback on more "what is depends on" sort of things so I can be confident I've chosen the right method for the current projects. Here's the situtation: I have multiple…
Possible to strip cell formatting out for reports?
We're trying to generate multiple reports from a master smartsheet that we use to track various projects. As part of using the master smartsheet, we have certain practical cell formatting options we use to easily see progress or potential trouble spots at a glance (e.g. color coding certain cells base on conditional…
Sheets, or partial sheets displayed in 'Sights' dashboard
I know several of us use cell linking to creat roll-up reports of our data, but these reports cannot be displayed in a 'Sight', becase they live on a sheet, not on a report. Is there a way, or can i recommend a functionality, that allows for a sheet, or part of a sheet to be put into a sight for quick visibility?…
Single-row reporting from multiple sheets
In the reports I've used so far a new row is created for each sheet data is pulled from. Is there a way of combining the results on one row where the primary column is the same? For example, if I have project RAG status in Sheet1 and project financials in Sheet2, and both sheets have the identical project name as the…
Copy & Paste Conditional Formatting to Another Sheet - Request
While starting new projects in Smartsheet via a template is great, I often have to start a project by importing an MS Project file. This means that I have to replicate all of the conditional formatting that we use on all existing Smartsheet sheets. Since we take advantage of the good conditional formatting options that…
Totals of column data
Is there anyway to total columns other than using a parent?
