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...
Why not you use FILTER() function?
Can you show me with how this formula fits in using FILTER() in a working condition? I already attempted this with FILTER in previous iterations:
=IFERROR(FILTER(]'DevOps Tasks\'!C:C,\'DevOps Tasks\'!H:H="COMPLETE"),"")'
Same repeating with !D, !B, !A with no success.
Can you please attach a sample with sample input data and showing your desired output? You may also share the file with OneDrive, Google-Drive or Dropbox.
