Forum Discussion
Auto-Populating Data From One Sheet To The Other
My structure is 2 separate tabs in the excel sheet. In one sheet, my "Devops Tasks" sheet, I have a status of "COMPLETE", and currently, everything besides 2 are set to "INCOMPLETE". When I se...
Seems incorrect use of @ symbol, the @ symbol is used for structured references in Excel tables. If you are not using tables, remove it from your formula.
Assuming you want to count the number of "COMPLETE" statuses and then get the data from the corresponding row, if yes, please:
=IF(COUNTIF('DevOps Tasks'!C:C,"COMPLETE")>=4, INDEX('DevOps Tasks'!B:B, AGGREGATE(15, 6, ROW('DevOps Tasks'!C:C)/('DevOps Tasks'!C:C="COMPLETE"), 4)),"")
Make sure your formulae in JavaScript
{ formula: `=IF(COUNTIF('DevOps Tasks'!H:H,"COMPLETE")>=${index + 1},INDEX('DevOps Tasks'!C:C,AGGREGATE(15,6,ROW('DevOps Tasks'!H:H)/('DevOps Tasks'!H:H="COMPLETE"),${index + 1})),"")` }
