Trending in Formulas and Functions
-
Count # of networkdays if a condition is not met
Hello, I want a formula to count the number of workdays between when an item was assigned only if a condition is not met. =IF(Request Status - Contracting]@row <> "Contract work Complete", [Date Assigned to CM]@row, TODAY()) I want the # of days counted since an item was assigned to a manager only if the manager has not…
-
Formula to surface specified data and date from project task
I am trying to to surface to latest EOT from the task to row 1 on EOT Stage, and respectively the corresponding End Date to EOT End Date row 1. We may state EOT 1 - 5 on the project sheet, but it will only take effect the date is filled in. Therefore, the latest EOT need not necessary be 5. But in the following example, I…
-
I am trying to get the percentile of responses that return "1-2" if the responded "4 Months" in
I am trying to get the percentile of responses that return "1-2" in a column if the response is "4 Months" in another column. =PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, "4 Months", 0.5)) or =PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, {Survey Time}, "4 Months", 0.5))…