AravindGP·Principal Consultant at atturra·✭✭✭✭

Comments

  • Hi James, Unfortunately, at the moment, Global Updates in Control Center doesn't support updating/modifying formulas with cross sheet references. You will need to open each individual sheet to update the reference.
    inControl Center Find/Replace to Edit Cross Sheet Reference? Comment byAravindGP 07/11/23
  • Hi @jacquedale You will need to change the formula to SUMIFS to get the total sum for your criteria. =SUMIFS([Daily Weld Count]:[Daily Weld Count], Contractor:Contractor, "Contractor name", Date:Date, "your date criteria", [Shop/Field Weld]:[Shop/Field Weld], "Field Welds")
    inFormula help Comment byAravindGP 07/11/23
  • Hi, You don't really need to add "@cell" for the criteria in region and service line and you will need to change the row index to 1 instead of 0 to get the value.
    in#Contact Expected Error Comment byAravindGP 07/11/23
  • Hi Tiffany, Is the report grouped? This usually happens when you have a grouped report that is collapsed. Unchecking the option will remove the green pop up that appears on the widget.
    inHow do you remove the "Open Source Report to View More" pop up from widgets? Comment byAravindGP 07/11/23
  • Hi There, Automation runs on calendar days. If you would like for the row to be moved 10 days after the Date Completed, your trigger would be "When a date is reached", after the "Run Once" dropdown, where you have a dropdown for "On", change it to "2 weeks after" and select your "Date Completed" in the Date field as you've…
    inAutomation - Moving to a row to a new sheet once a date has passed Comment byAravindGP 07/11/23
  • Hi, It looks like you're trying to get the max value rather than summing up the values in your Engagement column. If my understanding of the scenario is correct, the formula you could use would be =INDEX(COLLECT({TEST SDC RANGE 4}, {SDC Rev0 Range 2},[email protected], {TEST SDC RANGE 3}, MAX({TEST SDC RANGE 3})), 1)
    inFormula help with SUMIFS. Would like to incorporate an IFMAX in there somehow. Comment byAravindGP 07/11/23
  • Hi Colin, Check if the workflow's conditions, if any are appearing in the sheet. When the workflow says it ran, it means that the trigger was activated. However, successful completion of the workflow depends on the conditions being met which will follow through with the action, in this case the update request. The way to…
    inHow can I verify an update request was sent? Comment byAravindGP 07/11/23
  • That's great! Having all of the values in Sheet Summary might be too much. You can create a separate metrics sheet and have one column with February 2022, March 2022, April 2022, etc. as rows and in the second column have the formula to count the number of submissions against these months. The formula you would use would…
    inAsked to Calculate Average Monthly Submissions Comment byAravindGP 07/11/23
  • Hi, If you are planning to tag the parent at Risk even if you have one of the child rows at risk, you can write a formula in all Parent rows as =IF(COUNTIF(CHILDREN(Risk column), 1)>0, 1, 0). If you want parent rows to dynamically have this formula and not the standard formula, you will need to have a helper column to…
    inHow can I flag a parent task if 1 or more children tasks are flagged at risk? Comment byAravindGP 07/11/23
  • Hi Becky, You can add the If statement before the index/collect. So your formula would be =IF(HAS(Range of the column that has Weekly Date Start, "04/24/23"), INDEX(Collect({PM Weekly Allocation Week hours}, {PM Weekly Allocation Project Name}, [Project Name]@row), 1)). This will collect the total time clocked against…
    in索引收集If语句 Comment byAravindGP 07/11/23
Avatar