-
Formula to Automate Stage
Hello - I am trying to figure out if there is a way to automate the selection of one of three stages (Not Started, In Progress, Completed) based on Start and Due date columns. Activities with a Start Date in the future would be 'Not Started', activities with a Due Date in the past would be 'Completed' and anything with a…
-
AVG(Collect) Formula help with date range
Is there a way I can give a date range in the formula below so that it averages between dates 8/21/19 - 10/29/19 =AVG(COLLECT({Nexus Dependencies Range 5}, {Nexus Dependencies Range 1}, "The Scrum Lords", {Nexus Dependencies Range 3}, DATE(2019, 10, 29)))
-
Formula issue for conditional formatting
I am trying to set up a formula to allow for conditional formatting but having some problems. This is the formula I'm trying: =IF([Actual]19 >= [Target]19, IF([Actual]19 < SUM([Target]19 * 0.1), IF([Actual]19 > SUM([Target]19 * 0.1), "GREEN", "AMBER", "RED")) but the result leaves the cell blank with no error message. What…
-
Retrieve most recent values in multi-select column using formulas
I am struggling to get the formulas to retrieve a value in a multi-select cell. For example: Flavor options in multi-select dropdown: Vanilla, Chocolate, Mint Flavor1: Vanilla (row 1) Flavor2: Vanilla, Chocolate (row 2) Flavor3; Vanilla, Chocolate, Mint (row 3) In a separate column I want to use a formula to retrieve the…
-
Formula Help!!!
I'm having issues with making this formula work for the RYGB Balls. Any glaring mistakes? -Green – An open request that was received 1-5 days ago. -Yellow – An open request that was received 6-10 days ago. -Red – An open request that was received more than 10 days ago. -Blue - Complete -Blank/No Date - Blank status…
-
Calculate Date Employee turns 18
Can anyone provide a formula that calculates when an employee turns 18, based on a DOB (date of birth) cell. I've reviewed the forum and found formulas that return an age, but we need a date so we can set up a notifier email to alert payroll for some HR requirements.
-
Conditional Formatting if Checkbox is Checked
Hello everyone, I created a checkbox column with 3 cells set to toggle on and off conditional formatting rules. My idea is to paint certain cells if certain conditions are met AND one of the 3 cells is checked. I'm doing this mainly for aesthetic purposes as I don't want to have my sheet multicolored all of the time. Using…
-
Formula for Status
I have a team task list sheet that has a drop-down Status column including Not Started, In Progress, Urgent, On Hold and Completed and we use card view for this. I have a % Complete column that is a text/number field and a Progress symbol column (Empty, Quarter, Half, Three Quarter & Full). Is there a formula that could be…
-
extracting the email adress of a contact
Hi, I'm not able to use the email adress of a contact in another cell. I need this for building a specific link in another cell. e.g. https://blabla.com/#browse/profile/john.doe@gmail.com ="https://blabla.com/#browse/profile/" + contact2 will not work :-(, it returns the name of the contact. Any idea how to get this…
-
If Formula
Hi I'm trying to auto calculate the date. I was wondering if someone could assist. I'm not quite sure how to do it I believe it should be an if statement but I'm not sure how to write it. I have a column that is Date of Last Correspondence, Days till follow-up, Next Follow up Date is the column that I want to auto…
