-
How do you create a dynamic list of unique values from multiple sheets?
I am trying to create a "level of effort" calculation where we compare the count of bidded, lost, and awarded projects against a specific criteria, which is often a dropdown column in the source sheet. I have tried using JOIN, COLLECT, and INDEX from at least a dozen posts in the Community but nothing has worked to date.…
-
How do I list all predecessors (direct and indirect) for a given row?
Does SmartSheet have a way to list out all of the predecessor rows that feed into a given row? For Row 22 in the example below, I would like the formula to return the values 20, 19, 18, 17, & 16. Either that, or I would be looking for a list of all direct and indirect successors to a given row. Either would get me where I…
-
Merged: Dynamic View Grid Lines / Column Freeze
This discussion has been merged.
-
Creating child rows with form selections
Newbie here! I have created a form for marketing requests. One of the drop down fields is for Marketing Avenues with 13 possible selections. I would love to find a way to auto create child rows for each avenue selected under the parent project row so we are able to assign those to different people and keep up with each…
-
Control Center Links and updating from report
I am using control center to create new projects and folders and linking to a Summary sheet. However I want to be able to create a report from the summary sheet and make updates to fields that will post back to the summary and the project. Is this possible? currently no matter what link option I use in the profile setup it…
-
Hello Everyone! About Me:
Hello everyone! My name is Kacie, and I currently work as a medical assistant. Recently, I’ve taken the lead on transitioning several of our projects into Smartsheet, and it’s been exciting to see how much more organized and efficient our workflows have become. I’m really looking forward to being part of this group,…
-
Track changes in Resource management for Smartsheet
I would love to see the highlight changes feature be expanded from base Smartsheet grids/reports to RM for Smartsheet, specifically schedules, to easily identify where dates have shifted and availability has been impacted.
-
Enable stacked bar charts built directly from Reports
When building a chart widget from a Report, Smartsheet currently only supports a basic bar chart. If I try to create a stacked bar chart from a Report (to split the bar by a second field like Status, CoC, Portfolio, etc.), it does not work as expected. This limits dashboard reporting because Reports are the cleanest way to…
-
Highlight Changes Feature
When multiple collaborators are working in the same Smartsheet and the Highlight Changes feature is turned on and set to “I last viewed this sheet,” will the highlighted changes only appear for the first person who opens the sheet, or will each user see highlight changes based on the last time they viewed it? I am unable…
-
Flag projects at risk
Hi community experts, I'm trying to flag projects that are at risk. A project should be marked "At Risk" if the Status is not Complete, the Due Date is within the next 7 days, and the % Complete is less than 80%. Otherwise it should show On Track. What formula can do this?