Formulas

 

Discussion List

  • Project critical path filter

    Hey, We already have a native way to highlight a project's critical path: But is there a way to implement a filter based on this criteria? I would like to be able to run a portfolio level report to show me all critical paths across projects. Thanks for your help, Matt

  • Multiple contact list cross linked with a single choice list

    Dear Community, Can you please advise? I have a sheet where among other columns I have a column listing contacts "Champions" (multiple per cell) the other columns are for example: Countries (a list of 72) The list of Projects (approx 15) - I can add to that sheet, or I can create in a Helper Sheet. I haven't done that yet…

  • Filtering Graphs in Dashboards

    I've created a dashboard with multiple graphs using data from the same report. I have added the report to the dashboard as well and set up the filter for use in the dashboard. Is this filter transferable to the graphs as well, given i can filter the report in the dashboard?

  • Approval Date to Completed/Archived Date Duration

    On one sheet we have the Approval date column - this records the date as to when the project was approved. Then there is another column that records the date when the line gets moved from the active projects list to the completed/archived project list. A date will not be filled in until this time. Is there an easy formula…

  • Can an if statement be used with index collect? Looking for value on two different sheets.

    Looking for assistance again, I want to bring in the % complete from the Production sheet to the Schedule sheet, but once the % complete is 100 the data is moved to another sheet, so I would like to reference to check 1 sheet for percent complete and if it is not there check the second sheet. Schedule sheet: Pick Up Date…

  • Table View - Show column links AND formula in row header

    Currently, if there is a formula in a column and the data is part of a column link where that formula data is being sent elsewhere, the column only shows the Column Link icon… and doesnt show the formula icon. It gave me a minor heart attack today!!

  • Formula to auto-calculate 500 rows in a set

    Is there a formula I can use that will "divide" a page? I have about 2,000+ records on each page; And for the sake of backup, I need to divide it out into units of 500. Whatever the final item is will probably contain 500+ records. Such as 4 new sheets of 500, and then 1 sheet of 600 for example? Is there any formula I can…

  • How to calculate if a date is 6+ months away, 3-6 months, and <3 months

    Trying to figure out a formula to calculate if a date is 6+ months away, 3-6 months away, <3 month away, or if the date has already passed. The desired output is 1 if 6+ months, 2 if 3-6 months, and 3 if <3 months or already passed.

  • Convert Value To Static

    I need help, please! I created a process that allows employees to request deactivation periods from their snow assignment. The ogranization allows for 5 employees for days and 5 employees from nights to deactivate at one time, per day. I am using the following formula to retrieve the number of slots available:…

  • Help needed - Conditional Formatting a multi-answers cell

    Hi all, I have tried about everything I could to create a functional rule of conditional formatting but to no avail. Here is a detailed look into what I have and need : I have around 5 different columns for which I need a rule to apply individually. Basically, each column respresents a task, while the row represents in…