-
Automatically change Status RYGB
Any formula to automatically change status from RYG to B once my project reached End Date?
-
Formula to populate multiple contacts into a cell based on role
I used the following Match/Index formula to populate the "Assigned To" column of my sheet based on the "Role" column. I have a look up table at the top of my sheet. =IFERROR(INDEX([Assigned To]$6:[Assigned To]$20, MATCH(Role@row, Role$6:Role$20, 0)), "Needs Role") There are many tasks on my sheet which are assigned…
-
SUMIF - all options EXCEPT one (NOT function?)
Hello, I am having some issues trying to create a formula to sum all the values in the column (called Scheduled Anode(s)), except for rows where a status column reads "No action required". This was my best attempt, but it doesn't give the result I want, it sums to 0 instead of the 40 or so value it should be.…
-
Ignore negative: Calculate time between dates ignore negative numbers
I am running a formula to calculate the days between a start date and today(), if the number is less than 25 then it inserts today's date in a cell. That cell is then used to trigger an email to a user for action. If the start date is in the past the calculated days between is a negative. I want the formula to ignore the…
-
Multiple IF Statements -- Status Updates
Hello, I am trying to put together a sheet that reflects as a holistic "Status Update" depending on whether or not something has been "Approved", is "Pending", or has been "Denied". I attached a photo that shows what I am trying to get my sheet to reflect and what is happening with returned values. Here are the examples of…
-
Multi-Select & Automated Notifications
I'm trying to create an Automated Workflow for Requesting Budget Updates. We some times have to send out Update Requests for Monthly Budgets - obviously the number of months will vary client to client. My question is - is there a way (using Conditions, Formulas, etc.) that I can setup one Automated Notification that would…
-
Hide #INVALID VALUE or Display Alternative
Hello! I'm using MATCH with COLLECT to return a value based off the two criteria of an ID and Today's Date in an "Intake Sheet" populated from forms. This data will be populated daily and I would like to: hide #INVALID VALUE when there is no value or display something such as "No Data". =INDEX(COLLECT({DailyUnits},…
-
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.
-
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-…