-
Filter reports - How to
I'm building a late task report across multiple workspaces/plans. The filter option is not available when viewing report results. Looking to be able to filter by "Status", "Owner", etc.
-
If / then statements with subtraction problem
Hello everyone, I was hoping some of the pro's on here could help me figure something out. I'm creating a hours tracker for employees to use remotely and I need to calculate the overtime hours as anything over 8 or anything over 10 depending on the answer given in a column. So if [certified] = "Yes" then subtract 8 from…
-
Expected Progress
Hi, which formula can I use to calculate the expected Progress (depending on the current date)? Thanks
-
Un-editable drop down cells in a report.
I am trying to make a report with a column that has a drop-down with preset selections. The problem is that when I try to access that column from the report sheet (not the master sheet, master sheet works just fine), the drop-down column is un-editable (greyed out). If I set it as a text/number type column, then I can edit…
-
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…
