-
IF cell CONTAINS one/two/three different values, return corresponding values
Hello community, I am attempting to return single or multiple values depending on a multiple dropdown column. My dropdown column contains criteria "Consolidation", "Reduction", "Termination", "New" Currently the formula works for single values with the following formula =IF([Type of Project]@row = "Consolidation", "🝢",…
-
How to extract part of a cell and remove the rest
Hello I have a very long column with various texts in every cell containing for example 'Data change request from John Smith', every cell contains different types of requests and I want to extract to another column only the text before the word 'request '. Could you please help me how to do this? Thank you so much!
-
Automated Email 2 days after a date if no attachment
Hi There, I have a fair bit of automation setup in my workspace for all the relevant rollout / install sheets to do multiple things including: Send reminders 1 and 3 days prior to ensure the store/retailer is aware and the space is clear Reminder on day of install at 5pm to ensure an attachment of the evidence of install…
-
Add multiple amounts together for multiple selections
I am trying to create a formula that can look at a column with multiple choices, put a number value for each option chosen and add them together for a total. So if they choose option A, amount is 400, option B, another 400, option C, 500, etc. the column would add those amounts together to get 1300. Here is what I have so…
-
Formula that combine names that falls into the selected dates
Hi, I have a sheet on which employee will submit their PTO request. The column "Team PTO" shows who else is having PTO during their requested dates within their department. Here's the formula: =JOIN(DISTINCT(COLLECT(Employee:Employee, [PTO Start Date]:[PTO Start Date], >=[PTO Start Date]@row, [PTO End Date]:[PTO End Date],…
-
Referencing value in previous row to assign a contact
On a Requests Sheet, I have a column for Assigned Supervisor. I want to write a column formula that will add a contact based on the previous row's assignment. I'd like to rotate through a list of supervisor contacts each time a form is submitted. I created a separate Assignment sheet that has a column of the Supervisor and…
-
Help with date formate
I have my months extracted from a date column using =Left(EISD@row,2) I need a formula to evaluate my month column, if it's 01-06 it returns an S, if its 07-12 (or <=7) then it returns an F.
-
Formula to Link PTO Tracker to Project Schedule
Hello, I have created a PTO tracker to log my project team's PTO during the project lifecycle. The PTO tracker that I created is a separate sheet from my project schedule. Is there a way that I can create some conditional formatting (maybe via a checkbox helper column) to link these two sheets and indicate where there is…
-
Identifying duplicates when company name changes without changing source data
I am keeping a running report on engagement with certain organizations across 5 years. We receive a data export from a collaborating partner with a list of hundreds of orgs, thousands of rows. Each year, several orgs may change their names slightly (for example, if Super Duper Inc. changes its name to SuperSuper Inc. or…
-
Help with Approval Workflow
I have been trying to figure out how to efficiently create the approval workflow described in the attached spreadsheet. I have hit walls so many times, I am now confused and my brain is fried. Can anyone help?