-
Total Cost Based on Date of Task Being Finished
I am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily accessible. I have tried reports but that only displays all of the costs and does not…
-
Metrics from Report for Sight
I currently have a sheet for each account manger that lists there account and a few key metrics. I then created a report that brings in all of the 10 sheets into one place so I can see our entire portfolio. We move/add accounts often so the report allows me to see total book in a much easier format than linking. I have a…
-
Merging A list to show unique value/identifier
Hi Smarties, I am wondering if anyone could share some ideas on this. I have a list of available products. Some of these products are repetitive in the list. For example I would like to show a list of AVAILABLE products in the dashboard, but without the duplicated products. So ideally, it should be showing in the dashboard…
-
Show milestones along a row with multiple dates
It is possible to show milestones along a single row with multiple dates per the screen set below?
-
IF Condition issue
Hi, Can someone help me why i am just getting the value as Quarter if i change the value to less than 25 in column =IF([1.1 Landscape]1 > 0.0025, "Quarter", IF([1.1 Landscape]1 > 0.005, "Half", IF([1.1 Landscape]1 > 0.0075, "Three Quarter", IF([1.1 Landscape]1 > 0.001, "Full", "Empty")))) THanks
-
Automating weekly report
Hello, I currently am trying to automate a process but having few issues:I currently send out an email manually to send their top 3 accomplishments, top 3 issues for last week etc. I am trying to automate the sending out email. I want to keep the historic data but do not want multiple columns with each week. Is there a way…
-
Can a dashboard be exported to a Google slide deck?
I would like to take parts of a dashboard and roll the data into a preestablish Slide deck
-
How to hide the item # column & reduce header size in a published report
In the below example, I have embedded a report widget (top) and a web content widget (bottom) in a dashboard. In a published web content widget, is there a way to hide the item/row # column, and a way to reduce the header size to appear similar to the report widget? Thanks.
-
Printing Reports
There seems to be a disconnect between what appears on the screen of a report vs what gets printed. Has anyone found a work around on this? Specifically, we are trying to keep the groupings to remain on the printed version but when we got to print, it removes all of the groupings and just lists the rows out. We did find a…
-
Actual vs target Date
Hi, Need a help if my Start Date is 05/24/2021 and end date is 07/01/2021 and in my project plan sheet say i have a task that start on 06/24/2021 and end on 06/28/2021 .However, that task is already been completed and the actual % Complete has been updated to 60% for that task i want the schedule Health should be turn to…