-
Sort columns by color
Hi, Is there anyway to sort columns by fill color or text color? When we need to draw attention to certain items in Smartsheet In Excel we use color coding to sort. That ensures that the specific criteria requested will be presented on the top...(not all the criteria are the same ex. by date, so conditional formatting…
-
conditional formatting between 2 columns, same row
is there an ability to set a conditional format based on two columns in the same row: completed (column) date is later than the due (column) date – the cell turns red completed date entered is before (or after) today's date
-
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…