-
Manage same tasks for different locations
Hello community, I'm looking for the best way to manage project that has 3 different locations but same tasks need to be done in each location. Currently I use indent lines but if I need to add new task, I need to make sure I add this line under each location. Any other idea? Thanks Michal
-
Analytics for Dashboard
Hello, is there any analytics available for dashboards that are shared either to users in the workspace, or public access? For example, the traffic to the dashboards, the clicking on the various metrics/charts/reports? Thank you.
-
Why isn't my automation working correctly?
In my sheet I have a column with a countif formula that's referencing another sheet. I have an automation that sends an approval request when this column changes. When the value changes for some reason the approval request is not being sent. Any ideas on whats going wrong here?
-
Managing permissions for sheets that will be updated via reports
Hi, I have a sheet that I want users to update using a report. It would be best not to open the sheet up to the full universe of users, but new users are added frequently and I don't want to continually be updating the permissions for the sheet or a group. What are the best options for doing this? The report I am using is…
-
Sending empty report
Hello, i have a question about reports. i have a sheet with tracking of my manufecturing per customer and i generate a report for status per customer. and every week on Sunday ths system send via email the reports in EXCEL format. my question is: in week that the report is empty customer has no products in production…
-
COUNTIFS Blank, Not Blank
I need to count the number of contracts in a column that have a BLANK contract status. I'm counting the Contract Amount column but don't need to sum it. Here's the formula I've started: =COUNTIFS({Contract Amount}, ISBLANK({Contract Status}, @cell)) Any ideas?
-
Can indented rows in Smartsheet show their parents in 10,000ft?
I am using 10,000ft to visualize my resource allocation. I am using a Smartsheet project plan do the actual allocation, and in this project plan I have "phases", "tasks" indented to those "phases" and "type of resource" indented to those "tasks." When I go to 10,000ft, however, in my schedule I only the resource and the…
-
Checking Off All Child Rows When a Parent Row Is Checked
Good afternoon We need to be able to archive scope items from our sheet . Each Scope item a child parent relation ship We want to be able to check off the children with the parent is checked off so we used =parent(), however when I try to click the parent row it is not allowing me Am I doing something wrong ?
-
Export a PDF of a Dashboard
When I export a PDF of a dashboard which contains reports, I lose the formatting of those reports. Is there a way I can export a pdf that includes the formatting from the reports. More specifically: I have highlighted rows on my report. I then bring the report into a dashboard that I wish to export. When I export the…
-
How do I create a widget on a dashboard that can change the date in a sheet summary?
Hello all, I am wondering how to add a widget to a dashboard that can be changed from the dashboard, and change the date in the sheet summary. The date field in the sheet summary changes the information in the summary, and the information on the dashboard. Thanks.
