-
Formula Help
I am trying to match a cell on our contract status report and pull that cell information into our recruitment sheet. On the contract sheet name is in the first column and contract status in the sixth column. I want the contract status to populate into a cell on the recruitment sheet by name. I was thinking that VLOOKUPโฆ
-
HELP:Automate Status for Range of Dates
I am trying to construct a formula that will make the status turn yellow when TODAY() is 4 days to and 4 days after the date in the [Due Date] column. I was hoping the following would work but it does not: =IF([Due Date]8 <> TODAY(4), "Yellow") Any ideas on how to write an if formula to cover the date range?
-
Nested IF Statements for same date
Hello, I'm trying to create a Nested IF formula utilizing the status bars and due dates. What we're trying to say in English is: If more than 5 days til due date = Green If within 5 days of due date or equal to due date, = Yellow If past due date = Red I can get certain parts of the formula to work by themselves, butโฆ
-
COUNTIF between dates
Hello I have read a few posts about calculating values between dates but I'm still having an issue. I am trying to calculate a numeric value (basically a go-live date for 3 different project types) within a specific date rage. I want to calculate how may clients are brought live between April 1, 2018 and June 30, 2018. Theโฆ
-
Using a COUNTIFS formula to calculate # of rows in a set date range
I'm trying to calculate the number of tasks completed in the prior fiscal year, to be used as a dashboard metric. I've created a sheet that uses a COUNTIFS fomula to reference the relevant column in another sheet. Here is my formula, which returns a '0' result. =COUNTIFS({Completed Date},">=07/01/2017",{Completedโฆ
-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %โฆ
-
searching column for value to do checkbox
I'm trying to set up notifications for milestones that my team hits, looking for a specific ticket # in a column to send a notification when this ticket # is hit (for example, "Hey team, we just closed our 150,000th ticket. Amazing work, everybody!!"). I have tried using a checkbox column with formulas like the belowโฆ
-
Flag Red if under 100% or Past Due
Hello! Here is what I am trying to accomplish! In the column with the flags (highlighted yellow), I would like the flag to turn red when the Percent Complete Column (highlighted Green) is less than 100% OR if the Completion Date Column (Highlighted Blue) has a date past today's date. Please let me know if you can help withโฆ
-
Formula to count back 30 working days
How do I create a formula to subtract 30 business days from a certain startย date? I was trying to use =WORKDAY ([start date]13, -30) and it's not working. Note: the 13 is the row with the date I'm counting back from. Thanks for your help!
-
Is there a way to define "today's" health, based on today's date and corresponding "% completion" va
Hey everyone, I've got a set of data pulling in completion % by date, and want to give my team a quick snapshot of overall health of the project based on completion % for TODAY(). I have used the following formula, which works for giving RYG per day: =IF(AND(Date9 = TODAY(), Difference9 < 0.05), "Green", IF(AND(Date9 =โฆ