Translating Excel Formula to AppSheet

Hello everyone,
I’m currently trying to create a column variable (called “Sequential Count”) [refer to image] that counts in sequence the number of times a component is entered. Is there a way to do this in AppSheet? Excel Formula attached to the image.

Thanks

Solved Solved
0 7 529
1 ACCEPTED SOLUTION

Try:

COUNT(
  FILTER(
    "table",
    AND(
      ISNOTBLANK([Component]),
      ([Component] = [_THISROW].[Component]),
      ([_ROWNUMBER] < [_THISROW].[_ROWNUMBER])
    )
  )
)

View solution in original post

7 REPLIES 7

Steve
Participant V

Hi Steve, thanks for your help. I was wondering if you could help me structure this formula. Still having some issues with it. This is what I have done so far. Thanks

*=if(countif(Range,Component)>1,countif(Range(which moves one by one)),"")
** What im looking for.

So far I Know:

*Count(FILTER(“table”, ([Component] =[_THISROW].[Component])))
**This will count the number of components on the table but not in sequence. Also, How can I compare the count to a number (Expression: >1)

*COUNT(FILTER(“table”,AND(([_ROWNUMBER] >= 1), ([_ROWNUMBER] <= 1), ([Component] =[_THISROW].[Component]))))
** This will count if the component is in the range 1

how can I compare both so they are executed in sequence?

Try:

COUNT(
  FILTER(
    "table",
    AND(
      ISNOTBLANK([Component]),
      ([Component] = [_THISROW].[Component]),
      ([_ROWNUMBER] < [_THISROW].[_ROWNUMBER])
    )
  )
)

Hi Steve. It does work. Nice!!! Thanks. I just added -1 to the _RowNumber so the count starts at one.

COUNT(
  FILTER(
    "table",
    AND(
      ISNOTBLANK([Component]),
      ([Component] = [_THISROW].[Component]),
      (([_ROWNUMBER]-1) < [_THISROW].[_ROWNUMBER])
    )
  )
)

Hello @Daniel_Portilla , try this:

COUNT(SELECT(YourTable[UNIQUE ID],[Componets]=[_THISROW].[Componets]))

It counts the number of appearances of a given Componets depending on the one the row has.

Appsheet app formulas only calculate on their own when the row is added, so the range will always be up to the newest row.

Thanks for your help but im trying to count in sequence every time a component is added. Refer to Image

Top Labels in this Space