About Daniel_Portilla

Daniel_Portilla · 02-02-2021

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 ima...

Daniel_Portilla · 02-02-2021

Hello to the Appsheet Community, I started with Appsheet about a month ago and I have been trying to solve a problem for a while.[Refer to the image below] I was wondering if it’s possible to have an icon display “On” for a specific state (Installed)...

Daniel_Portilla · 02-04-2021

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

Daniel_Portilla · 02-04-2021

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

Daniel_Portilla · 02-04-2021

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 ...

My Stats

Daniel_Portilla's Bio

Badges Daniel_Portilla Earned

Recent Activity

Translating Excel Formula to AppSheet

Icon display

Re: Translating Excel Formula to AppSheet

Re: Translating Excel Formula to AppSheet

Re: Translating Excel Formula to AppSheet