Share your product feedback

Add a new idea Subscribe
Status Future consideration
Categories Application
Created by Guest
Created on Apr 7, 2025

RELATED IDEAS

Utilize loops in worksheet objects

What is the challenge?

I cannot use a loop in a worksheet objects

What is the impact?

This limits the capabilities within Worksheets

Describe your idea

I would like to be able to use a for loop in the worksheet object.

Worksheet formulas can return arrays but there's no way to walk it.

  • Attach files
      Drop here to upload
    • Admin
      Nathaniel Collum
      Reply
      |       Apr 8, 2025

      Thanks for sharing this idea.

      This may not solve all of your use cases, but you can filter arrays in worksheets. For more information, see the support article on filtering arrays with logical operators.

      Example uses:

      • Show a count of all features with a type of “New” included in this epic

        • count(self.epics[self.features.type == “New”])

      • Show how many features in the current release have a completion date after a certain date

        • count(self.features[self.due_date → "2019-06-12"])

      • Show the number of open requirements on a feature

        • count(self.requirements[self.status == "Under consideration" OR self.status == "In development"])

    Idea management by Aha!
    Create your own ideas portal to crowdsource feedback
    © 2025 Aha! Labs Inc.•All rights reserved