-
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…
-
Nesting IF Formula
I am attempting to create a tracker and the current formula is creating the dreaded "#UNPARSEABLE". I essentially am trying to autopopulate a number into column two, based on the name entered into column one. When I utilize the formula =IF([Employee Name]1 = "John Doe", {Employee ID Numbers Range 1}) it works fine. But…
-
Editing Formula
Hi there, I have this formula in the Schedule Heath column (picture of sheet listed below). Currently, the default value for cells in the Schedule Health is Red. I want to change its gigantic formula so if the End date is blank, the schedule health stays blank too (instead of red). Appreciate your suggestions. Thank you!
