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
    27 1
    Answered - Pending Review 27 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
    30 8
    Answered ✓ 30 views 8 comments Most recent by Christina.R Formulas and Functions
  • Looking for most recent date
    In Formulas and Functions
    I have two sheets. The first is a tracker for up coming reoccurring tasks and the second is a copy of rows that have been completed. In the first sheet I would like to collect the date from the "date" column in the second sheet …
    Accepted
    749 8
    Answered ✓ 749 views 8 comments Most recent by Valerie_WPA 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
    8 2
    Answered - Pending Review 8 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
    20 7
    Answered - Pending Review 20 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
    23 7
    Answered ✓ 23 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
    13 1
    Answered - Pending Review 13 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
    19 3
    Answered - Pending Review 19 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
    68 1
    Question 68 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
    23 4
    Answered ✓ 23 views 4 comments Most recent by Syllica Formulas and Functions