-
What's wrong with my formula?
I know the answer has to be something simple, but I am just not finding the answer. If the Favorites column has a check mark, then populate (the cell containing the formula) with the Initiative Project Name. Maybe I'm not using the right function? 🤔 It seems logical to me, IF this row has a check, enter this data from the…
-
Help converting a simple IF formula to a column formula
Can someone advise what is wrong in the syntax that is causing it to not be converted to a column formula? =IF([Inherent Risk Level]1 = "Low Risk / Minor", "1", IF([Inherent Risk Level]1 = "Moderate Risk / Material", "2", IF([Inherent Risk Level]1 = "High Risk / Critical", "3"))) Thank you
-
Index/Match IF certain year
Hi, I am trying to populate a separate sheet with the Projected Fees by year. For example, I would like to populate a 2020 column with the Projected Fees from 2020, matched to the appropriate Client. I have tried different versions of INDEX/MATCH but not working. I would like to INDEX the Projected Fee and the Year (2020)…
-
How do I set up a notification for a specific row that contains formulas
I have a row that consists of formulas that are changed by other rows. How do I: Set up a notification for just one row (not column)? Set up the trigger to recognize when the product of the formula has changed? (i.e. if the formula in a column adds up to 150 this week and next week it changes to 200, that is a change that…
-
Sheet Summary: COUNTIFS formula to count up completed tasks
I have a schedule sheet with nested task sections. e.g., Parent Row is called "Copy Editing" and underneath that are children rows for 15 book chapters with Task Names like "Copy Editing - Chapter 1", "Copy Editing - Chapters 2-3", etc. I want a Sheet Summary formula that counts how many chapter rows have a value of 100%…
-
Referencing data from other sheets
I need to create a sheet (let's call it Sheet 1) that references data from several other sheets IF a certain box is checked in those reference sheets. For instance, If the box is checked in any row of column B, Sheet 2 or column D, Sheet 3, the data from the Name, Date and Amount column for that row in those sheets would…
-
Move Rows to Another Sheet...that contain formulas
Hello! Has anybody had experience trying to automatically move a row containing formulas to a new sheet? I am trying to pre-populate cells with formulas that would apply on a different sheet so that they will be ready to go once moved over during a workflow.
-
Countifs a column with values and Invalid value error
I have a summary sheet that counts the number of not started, in progress and done tasks. This summary sheet looks up the name (index, collect contains) of the parent (Epic) of the tasks (Stories). Think Epics to Stories. The summary sheet has a column of Epic Names and a summary of not started, in progress and open…
-
Export with formulas intact
Hi guys! Is there anyway to export a sheet into excel and still have the formulas intact? Currently, exports only show values. Thanks!
-
If/Then copying cell information
I'm sorry if this is posted- I haven't found an example from previous posts that is working for my situation. I have 2 name columns- [First & Last Name] and [PI First & Last Name], and a third column for 'role'- [Study Role]. If the person picks the role I need (PI) I'd like copy the name of the 1st name column to the 2nd-…