- Duration in a summary task show "hours" instead of "days"
I have a series of sub-tasks in minutes and hours but then the summary task shows the duration in days. It is frustrating to not be able to change that, is it possible or could that ability be added to change the duration display in summary tasks? Thank you, - Blake Chesley
- Is there a way of allowing Editors the capability to Sort Rows?
I have a Current User report available consolidating many projects into one so it doesn't become overwhelming to the users. But it seems they have no way of Sorting is there an option for this? Other then Admin doing this?
- Smartsheet Sorting
Hi, Is it possible to sort data without having it sort the first two rows of data because the first two rows of data are my column titles. My column titles are just repeats of the smartsheet column titles. Thanks! Kevin Au
- Automating Project Status
Hello, I would like Smartsheet to automatically assign a project status based on duration and number of days behind project. I have specifically been asked to assign a project status of red if the task is 20% behind schedule. Please let me know if you are aware of how to automate this in SS. Thanks in advance for your…
- Sharing - keeping info confidential to relevant parties
Hello, My colleagues and I have a large database containing information regarding suppliers. I need to share the information that is relevant to each supplier, with that supplier. I can obviously run a report to pull the data out based on 'Supplier' column in our sheet, as there are a large number of suppliers on this…
- Report - Finish Dates
I have a report I use which gives me all tasks in my projects that are overdue, due today, or due tomorrow. (A screenshot of the report builder is attached, below.) It stopped working properly yesterday, when I updated some dates but the task did not drop from the report. Today, it's showing tasks that are due a week from…
- Best or Easiest Way to Report on Milestones or Summary Tasks?
I know that SmartSheet can distinguish between tasks that are regular tasks, or milestones, or summary tasks (because of how it represents them on a Gantt chart), but how can I leverage this information when I am trying to build a report on just milestones or just summary tasks? Is there some way to tell a report to filter…
- Report not picking up all checked Star symbols
我运行一个报告和使用一个明星symbol to filter what should be picked up from my sheet. The report is picking up all rows with stars checked except one. I have confirmed this row is checked. I have removed the Star filter to show all data and it works just fine, picking up this row. But when I go back to filter by…
- Report Sorting by Sheets Names Starting with Numbers Out of Order
Hello, I have a report being built off of 10 different sheets. Each sheet name is prefixed with a number and followed by the name (1. Project Name, 2. Project Name, etc). All was working well and the sheets were being sorted in the report by sheet name as expected until I came to sheet #10. Now the report sort order is 1,…
- Schedule automatic reports for updates
I have project teams of 10-20 people and each are assigned tasks. On a weekly basis, I want to auto-gen a user-specific report of their task items and send a request for updates on all items. For example, every Tues at 11 am, I'd like to have a report generate that contains all assigned items where the % Done is less than…