-
Nested if /or formula
Hello, I am looking to have a status bar (the one with empty, half, three quarter and full) look at two columns and give a result. I have percent complete and a "Done" checkbox. the percent complete is by date, so when the date gets closer the status bar shows progress. Here is the formula I am using to do so..โฆ
-
Changing Drop Down Value Based On Different Date Ranges
Hi All, Is it possible to make a drop down that will change its value based on a range of dates? I need the drop down to switch between "Past Due" (> today), "This Week" (today +7), "Next Week" (between 7-14 days from today), and "Two Weeks Out" (between 7-21 days from today). Is this possible? Thanks!
-
RYG Status Balls Formula Help!!
I am looking for help developing a formula for the following RYG Status Balls Conditions: If status is "not started", grey If it is 1 day before "due date" and status is NOT "complete", yellow If it is the day of the "due date" or past "due date", red If status is "complete", or "in progress" and it is 2 days or more awayโฆ
-
How do you use the Account Code in the Budget Management Template?
Hi, been trying to work out how to use the Account Code column in the Budget Management tracker. I need to add more rows but I'm not sure how to assign the account code for it to compute for the budget properly. Thanks!
-
Workflow to Automate Document Generation?
What's the simplest process for using "Document Generation" when a new "Form" is submitted? Does anyone have a workflow that can automate this process without the need for a "Gatekeeper" or someone manually generating the row-level document after the form is submitted? Example - We have a PDF form that requires a signatureโฆ
-
Turning Text into Checked Checkmark Field
Hello. How would I turn a "Y" text field into a checked checkmark column? Thank you.
-
Index Match Match Failure
Hi, I am having trouble with an INDEX, MATCH, MATCH formula. Basically what I want to do is say. If the PROCUREMENT COUNTRY and the DIV @ROW match then return the PROCUREMENT MANAGER from the DIVISION ASSIGNMENT BREAKDOWN sheet. =INDEX({DIVISION ASSIGNMENT BREAKDOWN Range 2}, MATCH([PROCUREMENT COUNTRY]@row, {DIVISIONโฆ
-
Schedule Health formula not working,
Hi, Can anyone help me with a formula i have three scenario .1 & 2. IF start date and end date % complete activity exceed the daily % completion , Status should be In progress and color the schedule health to Green 3 % complete is less than the expected work to be completed within the time frame it should be Red and statusโฆ
-
Adapt formula to use different cells if original source is blank
Hi guys, Once again I am hoping for some help. I have a formula that is working for me, however I have now added another couple of columns and want to adapt it slightly. The original formula is =((VALUE(LEFT([Task End Time]@row, FIND(":", [Task End Time]@row) - 1)) + VALUE(RIGHT([Task End Time]@row, 2)) / 60) + ([Task Endโฆ
-
Cross-sheet COUNTIFS formula
Hi All Help please i am trying to write a formula that will tell me how many Resignations we had in a specific year so i have =COUNTIFS({HR EX Employee Register Range 2}, ="2019", {HR Ex Employee Register Range 3}, ="Resignation") But it not working - Help what am i doing wrong