-
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…
-
Lock Columns
Each member of my team have their own report, they all have the same columns as part of their report however, each person is in charge to update the information of only certain columns. For example, if I have 4 columns name A, B, C and D and 4 reports each of them for 4 different people that are able to see the 4 columns.…
-
Task bar colors in report calendar view
The taskbars in my report calendar view aren't reflecting the taskbar colors in the underlying sheets, making it hard to tell which sheet the task is from. Anyone got any insight? Thx.
-
Reaching for Specific Information Return
I am trying to use a set of sheets for material tracking from various suppliers without actually having to have my employees use several sheets to do it. I am wondering if there is a way/formula to look through a specific column for a supplier name, and in whichever row it finds said supplier it then outputs that entire…
-
How to set up different projects + intake with same resources
Hi there! I am hoping that Smartsheet will prove to be the solution I am looking for, but I need a bit of help to get set up correctly. I currently manage a Design team in a tech org, and I resource two types projects with my group: - Long ongoing projects (these typically have one to two people assigned to them for 3…
-
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…
-
Centralizing rows assigned to individuals across multiple Workspaces
I have a project management workspace template that I create for each identical project (business startup). There are a number of items that are assigned to a group of individuals by department (HR, Procurement, EHS etc.). I used to keep all projects in one workspace and was able to create a report that would pull together…
-
Totals of column data
Is there anyway to total columns other than using a parent?
-
Filter what other can see&edit
My Company from Slovenia is using SmartSheet to track inquires/sales all over the world. Each inquiry gets its own line and we enter in this line also country from where demand came from. Curenty we use this sheet only internal- only in company headquarter here in Slovenia. Today our exclusive distributor from Germany…
