-
Multiple checkboxes
Hi there! I have two columns, for the sake of this example we can call them A and B. I would like to create a formula so that if A and B are both checked off, it will show the text "Sent" but if only A is checked the text will say "Reviewing". If neither checkboxes are marked I would like the text to read "Pending". Can…
-
Calculate End Date from "Start Date Plus Number of Days (calculated and rounded up via formula)"
Hello Community! I'm trying to calculate End dates based off of a hard Start date, and adding a number of Days that I have listed in another cell. The number of Days is calculated via formula, from one cell that lists Project hours (which I manually input) and each project is assigned to a crew, which have different…
-
IF Formulas for Status Columns
Hello, I'm looking for assistance in writing an IF formula to change a cell's value based on the value of other cells in the same column. Specifically, the values will be symbols. If all symbols are green, I'd like the first row to show as green, if any are yellow, then the top row should be yellow, and lastly if any are…
-
SumIFs formula #INVALID DATA TYPE error
Getting the #INVALID DATA TYPE error with this formula: =SUMIFS({Forecasts (SS) Hours}, {Forecasts (SS) Consultant}, $[Consultant Name]23, {Forecasts (SS) Start}, WEEKNUMBER(@cell) = 48, {Forecasts (SS) Cancelled}, 0, {Forecasts (SS) Start}, YEAR(@cell) = 2019) What's frustrating is if I change the ${Consultant Name]23 to…
-
Gantt View - Settings requests
Hi, I'm trying to create a dynamic 'To-Do' list (for want of a better phrase), that automatically steps the jobs - i.e. only start task 2 when task 1 is expected to complete. I want to make this as automated as possible, and I understand that dependancy columns do not accept formulas, but wanted to know if there was…
-
Modifying RYG Symbols with Dates and Status
We are trying to create a formula on the Schedule field that will change color to Red, Green or Yellow based on Multiple day and Status selection. For example: If Status is In Progress and End Date is > Today and R - Date is Empty then is Green. IF Status is In Progress and End Date is < Today and R - Date is Empty or a…
-
Managing Resources across multiple projects
Hi All, We have many concurrent projects running at all times. I am looking for ways to manage resource assignments across multiple projects. When I assign a resource for a specific project/task, I want to see if this particular resource is available around those specific dates. Also, I would like to see the global view…
-
HELP WITH INDEX FUNCTION
I have two columns... one with names and one with scores. I need a formula that will show the name of the person with the highest score. Is that possible?
-
Symbols using formulas
Hi there, I am creating a training matrix, so I have employee names down the left and the training programs along the top. I want to set it so that if for example "WHMIS" expires after 1 year then the symbol would go from green to red 1 yr after the "Training Date" and 30 days before the expiry I would like it to go…
-
Using Hierarchy Formulas & Conditional Formatting to Color Code Rows in a Sheet
I’m always interested to hear if someone else has figured out a better way to do something, so feedback is welcome and appreciated! (: Example Sheet: Hierarchy Formulas & Conditional Formatting I like to use colors to help guide me through a sheet and I have settled on a process that works for me. *See Picture* Minimum…