-
assign child rows from parent row
I have multiple parent rows each with over 30 child rows. I would like my "Responsible Party" cell in in each child row to be populated if I assign it in the parent row. I.e. I would like to select the contact (Responsible Party)in the parent. I would then like for each child row under to automatically be assigned to the…
-
Formula Within Next 30, 60, 90 days
Hello - Looking for help with a basic formula that will calculate how many projects end within a certain number of days. I have used: =COUNTIF({End Date}, <=TODAY(30)) I am not receiving an error message, but the result is much higher than the number is should be. Any help you can provide is appreciated! -Andrea
-
Ability to Adjust Axis Maximum
Hello, I'm opening a new discussion since the old version hasn't been responded to in some time. Stacked graphs are for some reason adding cushion on the ends. Is there no way to top these out at a certain number or percentage? In my case, I'd like to stop the percentage at 100%. Can we at least know if this is a priority,…
-
Calculating an Average based upon a value in other column
I have a calculation to calculate the number of days between two columns. =IFERROR(NETWORKDAYS([Date Submitted]41, [Go Live Date]41), " ") It works great to return a blank if the customer has not gone live. Then I have formula to calculate the average of the cells. =AVG([Number of Days to Implement]12:[Number of Days to…
-
Workflow Toubleshooting
I'm testing my workflows that have 2-3 approvers each, and the feedback I am receiving is that the approvers are all receiving 10-20 email notifications for the same request. Does anyone know how this might be happening?
-
Stacked Bar Graph
Is there a way to create a stacked bar graph with the new charts? Thanks! Chase
-
Set a flag 90 days before due date and after due date
I am trying to flag contracts needing renewals. What am I doing wrong? =IF(OR([Contract end date]1 <= Today1 + 1 - 90, 1, 0))
-
Checklist for Airbnb Cleaners
Hi all! I want to create a checklist for the cleaners who turn over my airbnb properties. I know how to create this checklist but there are a few specific things that I need it to do and can't figure out how. Any advice would be appreciated! 1) This checklist will need to be filled out each clean. That means there needs to…
-
Issue with chart widget on dashboard
I am pulling multiple reports into a dashboard. I am then making charts from these reports. One of the reports, will not measure the same as the others even though the criteria is the same. For example, the bottom % are showing 1% multiple times along the lower horizontal of the page. I want it to match the others which…
-
Formula -weighted for specific criteria
I have a complicated request. I want to create a formula that will provide a % when a row is designated as a "critical path" item. See screenshot. As a box is checked in the column for each cabin name, I want to get the % to update for those critical checked boxes. Is there a way to do this? I already have a formula that…
