-
Create charts without hidden data
Is it possible to create a chart without including the hidden data?
-
Locking view when sharing
Hello, I have used Smartsheet for some time now, but just started investigating using Card view. Unfortunately, Card view cannot be used on a report. Previously I had a report that combined my personal tasks as a manager from one sheet with tasks from my involvement in projects my employees are working on to create my…
-
Bug?: % Complete report filtering
Is this a Bug? I've set my report to display rows where %complete is "less than 100 or is blank" but the report continues to pull rows that are set to 100. This behaviour seems to be consistent in all my sheets, including this brand new one I created from a template!
-
completed tasks
How can I move completed taks to other location in the same sheet ? I have three different lists on one sheet: completed, active, not completed (as outdent and indent positions). How can I move completed tasks to required list ?
-
How to use data from another sheet as selection criteria?
Hello, I am trying to build a Report or ANOTHER sheet where I pull data only for Rows from another sheet that have OrderNr=OrderNr from the other sheet. The ordernumbers change daily. I need to be able to refresh automatically on a daily basis. Any recommendations how I should approach this?
-
Any limits on the number of dashboards?
Hi, Are there any limits to the number of dasboard a user can create? Many thanks, Grace
-
Referencing sheets
I am trying to decide between one sheet vs multiple sheets. I currently have one sheet but it has over 50-60 columns and there are sets of data that will be used by different areas. I know I can filter what is needed (to a point) with reports but it still doesn't give me the end result I need. Here is the breakdown in a…
-
Sending Scheduled Reports and Formatting
Conditional formatting does not appear to be applied correctly to scheduled report delivery. Details: I have a report generated that fgoes out @ 8am ET on M, W, F with logic to turn the row red if the task is past due and turn the row dark green if task starts today. The report looks like this when I view…
-
Using countifs across sheets to hold metrics for reports
We have a sheet that lists all of our projects (there are over 300 at the moment). We used to keep all of our metrics at the top of the sheet, but every now and again, someone would sort by a value that caused the metrics to get mixed into the project list. So when cross-sheet formulas (vlookup, countifs, etc) became…
-
Populating Parent with Child Cell Info
I am new to Smartsheet and was hoping someone can help with this logic expression, or let me know if this is even feasible. We inspect equipment (blue light emergency towers) bi-weekly. I would like to create a sheet that shows these inspections and automatically creates a work order/assignment for our various repair…
