-
More Sort Levels
Please add the ability to use more sort levels when sorting sheets and reports. It's pretty easy to run up against the limit of only being able to sort by 3 columns. In my personal experience there are cases I've hit where we would need to use 5 columns to have a sheet or report sorted in the most logical order. I'm sure…
-
Converting Cell Text to Hyperlink
Hi. I have a formula in a cell that generates the name of a course using text from other cells (e.g., BUS-430-BL-6W-1D-Master). FORMULA: =LEFT([Subject + Course]2, FIND(" ", [Subject + Course]2) - 1) + "-" + RIGHT([Subject + Course]2, LEN([Subject + Course]2) - FIND(" ", [Subject + Course]2)) + "-" +…
-
Mapping Data Mesh Sums from a Report to a Sheet
Hello, I've done a bit of preliminary research but haven't seen a similar issue discussed. While I know Data Mesh can bring data from a report to a sheet, is it possible to use it to bring over sums from a report into a sheet? I have a report which includes line-level financial data and have grouped that data by cost…
-
Sharing Report but Not the Source Sheet
I would like to share a report, but not the source sheet. The source sheet has personnel information that I do not want to share with our customer, but I made a report with the information I am comfortable with sharing. However, when I share the report, it is blank because the customer doesn't have access to the source…
-
Smart Sheet Use for Project Management - Meeting Agenda (w/ Form) to Action Item Tracking (Per Proj)
Hello everybody, First time poster. I've searched the forum to find a solution, but I wasn't successful, so decided to create my own post. I'm new to smart sheet, so would appreciate help in getting a solution for my workflow. Just as some additional information - we currently have numerous live projects at any one time,…
-
Employee Objective and Performance Reviews
I am looking for a real-world example of someone using the employee Objective and Performance Review Template for an IT manager? Do you find it useful and easy to use for managing your managers? Anything you can share would be greatly appreciated.
-
Merged: Find and Replace Function in Formulas
This discussion has been merged.
-
Merged: Customizable Sheet View(s): save specific hierarchy layout
This discussion has been merged.
-
Expand All/Collapse All Default View Setting
Would like to have the option to set the default view for a sheet with many parent/children rows, so that each time the sheet opened that default view would be shown. In other words, I'd love to have the default view at each opening of the sheet to show only the parent rows without having to choose collapse each time.
-
How can I use index match + either another index match or an IF statement to pull Data from multiple
How can I use index match + either another index match or an IF statement to pull Data from multiple sheets? In my case I have 3 sheets: Sheet 1 - Current Project List - consists information that track active projects. (each Project has a unique project code) Sheet 2- Closed Project List - consists of previous years…