-
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…
-
Reporting with on Sheets with Common Row Value
I love the functionality of creating roll-up reports that incorporate multiple sheets that have the same columns. What I can't figure out, and feel as though should be a possibility though is the ability to create a roll up report that combines sheets that have only ONE column in common. For example, let's say I am…
-
Schedule Health formula not working,
Hi, Can anyone help me with a formula i have three scenario .1 & 2. IF start date and end date % complete activity exceed the daily % completion , Status should be In progress and color the schedule health to Green 3 % complete is less than the expected work to be completed within the time frame it should be Red and status…
-
How do I avoid the cross sheet cell reference limit of 100,000?
I have several formulas that are critical to one of my dashboards. They reference a master sheet that grows daily in number of rows. I end up getting the cross sheet cell reference limit warning about every 15 days. Is there some way to easily mitigate this? I'd like to avoid reducing the size of the master sheet so…
-
How to count At Risk task to create a report?
Hi, I'm using a template and it already allow me to flag a column when At Risk. I would like to count how many items I have flagged, but i'm not sure how. I've used =SUMIF({Sheet - Request Tracker with Form Range 1}, "Red") =COUNTIF({Sheet - Request Tracker with Form Range 1}, "Flag") Thanks for your help