Formulas

Discussion List

  • Need formula to pull in names associated with RACI roles.
    In Formulas and Functions
    I have a Project Plan template that I would like my team members to save as new for each client and customize the information. Within the Project Plan, there's a RACI matrix with different roles. Please see below for an example: When a ne…
    Answered - Pending Review
    34 1
    Answered - Pending Review 34 views 1 comment Most recent by Julio S. Formulas and Functions
  • Is there a way to calculate the change of role in percentage?
    In Formulas and Functions
    Hi, I have a tracker, whenever the role/status change, it'll copy to this sheet. I'm trying to find a formula to calculate the change % from coordinator to admin, and from admin to the coordinator. Is there a way to do so? TIA!
    Accepted
    36 8
    Answered ✓ 36 views 8 comments Most recent by Christina.R Formulas and Functions
  • Nested If Statement Not Working
    In Formulas and Functions
    I am trying to write a nested IF statement to automate the RYG status balls in a status column. It will not work, it always say they are red. What am I doing wrong? Logic Needed: If less than 70% complete, "Red" status ball If …
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by John Johnson Formulas and Functions
  • Mean Time Between Two Dates from Form Submission
    In Formulas and Functions
    Hi Community, I'm attempting to find the average downtime of an asset between dates from a form submission for the month. For example below, I need to find the number of days between the "OOS Tag Removal Date" and "Date OOS …
    Answered - Pending Review
    25 7
    Answered - Pending Review 25 views 7 comments Most recent by Paul Newcome Formulas and Functions
  • Help: Formula Creation Request Please
    In Formulas and Functions
    Can someone help me by typing out what I hope is a simple formula? End result, when I update my "Status" column, I want it to enter the following amounts in my "% complete" column. FYI, Status is a drop down single ch…
    Accepted
    27 7
    Answered ✓ 27 views 7 comments Most recent by Collin Ice Formulas and Functions
  • #Invalid Operation error with simple Index formula.
    In Formulas and Functions
    I am getting an #Invalid Operation error with a really simple index formula. =INDEX(Contract:Contract, 2) This formula is in a Sheet Summary field. The summary field is text/number and the column referenced is a text/number column with a c…
    Answered - Pending Review
    17 1
    Answered - Pending Review 17 views 1 comment Most recent by Jeff Reisman Formulas and Functions
  • Can I create a Column Formula which automatically applies text in a Parent Row to the Child Rows?
    In Formulas and Functions
    When rows move into my sheet, I use them as parent rows for my projects. I want to have a column formula which automatically pulls in data from the parent row to its child rows. I've tried putting =PARENT() into a child row but it makes a…
    Answered - Pending Review
    23 3
    Answered - Pending Review 23 views 3 comments Most recent by Kevin Smith Formulas and Functions
  • Formula Help
    In Formulas and Functions
    Hello, I'm trying to create an inventory of all the items we currently have in our uniform room. The first column will have POLO Shirts USED through the year, the second column I would like to have our current stock inventory inside the …
    Unresolved
    88 1
    Question 88 views 1 comment Most recent by Alan P. Formulas and Functions
  • Calculating Days Remaining and Past Due
    In Formulas and Functions
    Hello everyone, I am trying to calculate the days remaining and days past due for each row, however, I want it to stop count if the status is closed. As you can see we have a "Days Remaining/Days Past Due" column and those closed…
    Accepted
    26 4
    Answered ✓ 26 views 4 comments Most recent by Syllica Formulas and Functions
  • Rich Formatting On "Summary Sheet"
    In Formulas and Functions
    I'm stuck! I am effectively trying to create a Sheet Summary report with conditional formatting, however, I understand that is not an available feature. Instead, I am trying to create a sheet (not a report) with formulas that pull from mul…
    Answered - Pending Review
    15 2
    Answered - Pending Review 15 views 2 comments Most recent by GabeHarris Formulas and Functions