Hi there, I'm building a schedule in Gantt View by back calculating from an end date. The issue I have (refer attached screenshot) is that I require the finish of the task at row 353 to be the earlier…
1. I want to aggregate text information from child cells and use a line break as delimiter. How can I do this? 2. In Addition it would be nice to have "Primary Column" as prefix before the respective …
I imagine this has been mentioned already, but it would be great if I could adjust lag time for tasks in the calendar view. The calendar view is great for load balancing, but it's a pain to have to go…
I am new to Smartsheet and I'm trying to create a report from multiple sheets that have parent rows and child tasks. I'm looking for a report that puts together all the sheets but only shows the paren…
I help develop Smartsheet sheets and reports, and link cells from project plan sheets to an overview portfolio sheet. Recently I've seen where some cells link properly, but some cells don't. I've trie…
I am new to creating dashboards in SS. I have gone through the SS online tutorials and not finding the details I need. I need to create reports using formulas and what I have tried I have not been suc…
There is an Task hierarchy created with the layer of 5 Main sub task. For this 5 layer Sub task Duration calculation is wrong when i tried with dependency and without dependency Can any one help me on…
I love the Filter for "Show rows that match" is one of "select values". I however would love to be able to paste from NotePad, Excel, an email, etc a list of values separated by line or comma (IE: 504…
I'm using the COUNTIF formula and am trying to set an open-ended range formula (see below). When I do so, I receive the error #UNPARSEABLE =COUNTIF(Test Result:Test Result, Status1) Is there any reaso…
Hello, I have a Workspace that will soon have several dozen sheets or more. I have a Template for this Workspace and a Smartsheet on how to use the Workspace for my organization. It is going to get ve…