Solved: Translating Excel Formula to AppSheet - Page 2

Daniel_Portilla · 02-02-2021 03:40 PM

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

Try:

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

View solution in original post