-
Remove all values from a multi-select column if they appear in a different column
I have two columns, one with a list of potential instruments and one with the instruments that aren't available. If I created a third column for instruments available, how would I remove the used instruments using a formula? All are multi-select columns
-
Pulling next date from a sheet
Hello! I am looking for assistance with a formula that can pull in the next action date from one sheet to another. For context, we use sheets for customer renewal project plans. We also have a tracker that gives an overview of all the project plans and their name, completion, next action date, status, etc. What I would…
-
How to change color in Status Column when checkbox is checked.
I am looking to set my Status Column to Blue if the Done Column (checkbox column) is checked. I think I am having an issue with referencing the checkbox column properly. Would love any help. Thank you.
-
Auto copy from one column to another, but only IF...
I'm looking for a formula to copy information from one drop-down column to another automatically, but only if a third column contains a certain word. Is this possible? For example: Column 1 could say say "Title" or "something else" Columns 2 and 3 have a drop down menu of "In progress" and "complete" If Column 1 says…
-
The dreaded #invalid data type
Hi guys, I'm progressing with my basic formula however what do i need to add into the below formula as an example so i don't get the unsightly #invalid data type in a cell just because the start date is blank? =IF(MONTH([Start Date]@row) = 1, "January", IF(MONTH([Start Date]@row) = 2, "February", IF(MONTH([Start Date]@row)…
-
Formula to populate parent from one column in another?
Hello, I'm am combining a bunch of sheets in one and then reporting off of that. For reference, the application is resource tracking, so lots of project plans that I'm combining in one so I can report at a "portfolio level". Is there a formula that will do this? I want the parent text from the Task Name column to populate…
-
Using Index Match for Multiple Value Dropdowns
Hello, I'm trying to utilize index matching for some metadata sheets and using the formula I am currently utilizing, the data appears blank. The formula currently being used is: =IFERROR(INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH([Impact/Benefits]$1, {Portfolio Summary Header Row},…
-
Workflows: copying values from one cell to another within the same sheet
Hello! I have a quick question regarding copying and inputting data. I am aware that rows can be moved or copied into other sheets via workflows. However, is it possible to create a workflow automation that copies/replicates data in "Cell A" into "Cell B"? The column properties of all the cells are set to Text/Number. I…
-
IF Statement between Ranges
Hello, I am not sure what i am doing wrong in the formula =IF([Current Risk Score]@row < 15, "36 Months", IF([Current Risk Score]@row > 70, "3 Months", IF(AND([Current Risk Score]@row > 16, [Current Risk Score]@row < 29, "12 Months", IF(AND([Current Risk Score]@row > 30, [Current Risk Score]@row < 50, "6 Months"))))))…
-
Can I use an IF formula to return a value where the reference column is a multi option drop down??
I am trying to create an IF or CONTAINS formula that references a multi option dropdown cell to returns an email address for every department selected in the cell. i.e. 'Other Departments Impacted' CONTAINS "Sales" "Accounts" "Delivery" so the 'Associated Contacts' cell returns "John Citizen", "Fred Smith", "Tony Dory". Is…