Formulas and Functions
Archives for February 2020
Discussion List
-
Is it possible to add dynamicaly a line ina summary sheet if a new sheet is created in a folder?In Formulas and FunctionsHi there, i manage several projects. Each project is in a individual sheet. I created a summary sheet to gather information from projects. When i create a new project in a folder, i wonder if it is possible to add this new project inside t…Answered - Pending Review 21 views 8 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Excluding Multiple OptionsIn Formulas and FunctionsI am having a real challenge with a particular function. I'm thinking someone will know this right off the top of your head. =SUMIFS({Digital Marketing Workflow- Total Hours}, {Digital Marketing Workflow- Priority}, <>"Sub-Cate…Answered - Pending Review 11 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
IF Statement helpIn Formulas and FunctionsSo, I am trying to create a column that adds the Student ID, when the Student is Named. This way I can make my reports de-identified. From a workflow standpoint, Teachers use a drop down for the Names on a Form and then enter Student Progr…Answered - Pending Review 1 view 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Formulas for calculate number of days depending on list of valueIn Formulas and FunctionsHi there, I need to know if it is feasible to obtain this formula : In a sheet, i can choose several option from a list of value ( checkboxes). If option A is checked, i add 1.5 days for ex. If i choose B, i add 1 day. If i choose A & …
-
Using VLOOKUP for Approval Requests Across SheetsIn Formulas and FunctionsGOAL: 1) Have a secure and error-free VLOOKUP on Sheet B and 2) Run a multi-level approval request automation on Sheet B. DETAILS: I have 2 sheets. Sheet A tracks contracts. It has columns for individuals (contacts) who are designated appr…
-
Changing % complete using a formula in another cellIn Formulas and FunctionsI know you cannot use a formula in a "% Complete" field. Is there a way to update "% Complete" from a formula in another column (something like a "helper" column)? I have a "Task Status" column wit…Answered - Pending Review 33 views 2 comments 0 points Most recent by BJ Patnode Formulas and Functions
-
How to find difference between 2 rows, but only if data exists in both rows?In Formulas and FunctionsHi, I'm trying to make a formula that says 2020 Experiential Audit minus 2019 Experiential Audit = value in Experiential Audit YOY change...but only if there is data in both 2019 and 2020. See my sheet below. I think this is an IF formula…
-
Can I lookup a value based on two criteria?In Formulas and FunctionsHi , I have two sheets, sheet 1 holds fixed data and sheet 2 is populated via a form. I want a cell in sheet 2 to return data from a cell in sheet one when two column values in sheet two are matched to two column values in sheet 1. Is this…
-
Duplicate value formulaIn Formulas and FunctionsI am trying to use a formula that will place a check mark in my duplicate check column if an invoice# in column 8 is a duplicate. I was using the =IF(COUNTIF format but it doesn't seem to be working for me Any recommendations This is th…Answered - Pending Review 42 views 1 comment 0 points Most recent by JReisman27 Formulas and Functions
-
Formula for % of checked boxesIn Formulas and FunctionsI'm requesting help to create a formula that will calculate the % of the checked boxes that are checked vs unchecked for calendar year with a project status of complete?Answered - Pending Review 21 views 3 comments 1 point Most recent by Genevieve P Formulas and Functions