Translating Excel Formula to AppSheet

[anonymous]

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

[Steve]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks ?

How do I do COUNTIF() or COUNTIFS()? COUNTIF(col, expr), where col is a whole-column reference (e.g., A), is similar to: COUNT( FILTER( “table”, ([col] expr) ) ) COUNTIFS(col1, expr1, col2, expr2, …), where col1 and col2 are each whole-column references, is similar to: COUNT( FILTER( “table”, AND( ([col1] expr1), ([col2] expr2), … ) ) ) To limit the rows included in the COUNT() range (e.g., as with COUNTIF(A3:A7, …)), include the limit crit…

[anonymous]

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?

[Steve]

Try:

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

[Rafael_ANEIC-PY]

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.

[anonymous]

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])
    )
  )
)

[anonymous]

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