squaladesign
Forms Fledgling

count if in the smartform

Jump to solution

 Hi everyone,

I'm trying to have some numbers in my smartform and I need to use a count if function that I didn't found. I'm trying to combinate if with count without any success 😞 

In the image here there is a part of the List View that I created and what I need to do i calculate the number of H1, H3, Yellow tag and Red tag for the whole table

squaladesign_0-1623358221683.png

How can I do that? In excel I have count if but I didn't found here.

Thanks

Labels: (1)
0 Kudos
Reply
3 Replies
Prineel_V2
Forms Fledgling

Re: count if in the smartform

Jump to solution

Hi,

 

You can do this using an expression and rules or probably just using an expression.

Here is my lisview, im counting all the "H1" items from my smartobject:

Prineel_V2_1-1623684029071.png

 

I have a expression that looks like this (Datalabel stores the count):

Prineel_V2_2-1623684108901.png

 

On my view execute rule, i have a for each rule, followed by an if statement and then followed by the set properties of my datalabel:

Prineel_V2_3-1623684201672.png

 

This is how my if statement looks (if smartobject field is equal to H1 the count-see next image for count):

Prineel_V2_4-1623684285781.png

Set the property of the datalabel to add 1 each time it finds "H1" using the expression

Prineel_V2_5-1623684393723.png

 

View solution in original post

Reply
squaladesign
Forms Fledgling

Re: count if in the smartform

Jump to solution

Uhhh nice, I will try, thanks!

0 Kudos
Reply
squaladesign
Forms Fledgling

Re: count if in the smartform

Jump to solution

Thanks so much, it's working and I also now understand hw to add "Advanced" formulas.

Thanks

Reply