tcanelli41471✭✭✭✭

I had to use decimals, but still not working 100%. Here is what I have so far: =IF([Minimum Level of Staffing Needed to Perform MEF]@row = 0.75, "Green", IF([Minimum Level of Staffing Needed to Perform MEF]@row = 0.5, "Yellow", IF([Minimum Level of Staffing Needed to Perform MEF]@row < 0.5, "Red", IF([Minimum Level of…

Yes that works - but why do we need a condition with it? I'd really just like the trigger and action parts with no condition. Is that possible?

Unfortunately no. I've already split the data into 4 tables. The issue is the number of columns and rows I need totals on.

but i don't want a total for both columns, just a single value if either column has yes. the OR statements are not working. and i even copied a working if(or from another sheet.

Thank you! I will try this.

Thanks. I have tried many variations to split this into multiple sheets but I cant figure out how to link the data I need. I even attempted it in appsheet thinking I could create the right references but no luck.

Thank you - that's where I kept ending up. I'll play around with that.

Can I ask you another formula question? I have to get a count for total under 17 and over 65. Would I do this on the date column or age column? Formulas are not my thing.

让它工作!谢谢你！

I keep getting unparseable error. I would love to have all my counts and totals on a completely different sheet but can't get the cross reference formulas to work either.