-
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…
-
Report filter that includes "Today" correctly shows the rows on the report, but not when displayed v
I have a report that is set to show rows that have a "Date Published" column where the Date is equal to today or is in the past. For examples sake 12 rows in total. 4 rows have a past date, 4 rows have today's date, and 4 rows have no date or a date in the future. When viewing the report directly, the report is correctly…
-
Report for files not modified in last 45 days?
Is it possible to create a report to list all files (sheets) in a folder not modified in the last 45 days? To be clear: I know how to run a report that shows the ROWS modified within the sheets. I want to know when the SHEETS themselves were last modified. Background: Currently I have a folder with hundred of sheets. They…
-
Send alert/notifications including headrow and children rows in the attachment
Hi All, I want to send automated notifications to my employees containing their absence records. To do so I need to be able to send their Head row (containing their remaining balance of sick days/holidays/bereavement leave ...) and their children rows (1 row per period of absence) as attachment. So far I can only do this…