Skip to main content


I’m tracking some healthy practices every day:


Exercise = Multiple Select (Running, Pushups, Squats)

Mediation = Duration

Healthy Food = Checkbox


And some negative practices:

Alcohol = Number


If Exercise is not empty, I want the Formula to return +1

If Meditation is greater than 0:10, I want the Formula to return +1

If Healthy Food is checked, I want the Formula to return +1


If 2 of these are True, I want to return 2

If 3 of these are True, I want to return 3


If alcohol is greater than 1, I want to subtract 1. So if all 3 positive behaviors were valid it would be 3 - 1 = 2


Then I will create a color filter and apply:


0 or -1 = red

1 = orange

2 = yellow

3 = green


I know this is a complex request, I appreciate any help you may be able to provide.


Thank you in advance

Hi @Greyson - you can do it like this:


IF(Exercise, 1, 0) + IF(Meditation/60 > 10, 1, 0) + IF({Healthy Food}, 1, 0) + IF(Alcohol > 1, -1, 0)


Basically, counting each column as 1 if a value exists, except for Alcohol which is -1 if greater than one, then summing each value.



There’s a bit of weird wrangling you need to do with the duration field - divide it by 60 to get an integer value, then compare to this (in your case 10, rather than 0:10)


JB

@JonathanBowen this worked perfectly, thank you for your help.

Reply


Terms & Conditions