Formulas
Discussion List
-
Need formula to pull in names associated with RACI roles.In Formulas and FunctionsI 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 views 1 comment 0 points Most recent by Julio S. Formulas and Functions
-
Is there a way to calculate the change of role in percentage?In Formulas and FunctionsHi, 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!
-
Looking for most recent dateIn Formulas and FunctionsI 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 …
-
Nested If Statement Not WorkingIn Formulas and FunctionsI 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 views 2 comments 0 points Most recent by John Johnson Formulas and Functions
-
Mean Time Between Two Dates from Form SubmissionIn Formulas and FunctionsHi 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 views 7 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Help: Formula Creation Request PleaseIn Formulas and FunctionsCan 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…
-
#Invalid Operation error with simple Index formula.In Formulas and FunctionsI 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 views 1 comment 0 points 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 FunctionsWhen 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 views 3 comments 0 points Most recent by Kevin Smith Formulas and Functions
-
Formula HelpIn Formulas and FunctionsHello, 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 …
-
Calculating Days Remaining and Past DueIn Formulas and FunctionsHello 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…
