Sign in to join the conversation:
Need help with my formula why isnt it working?
What is the purpose of your plus sign? Those are good for addition problems or inside a JOIN formula.
I think you're trying to use those for an AND purpose here, though. If that's the case, try: =IF( AND( [sitting]13 = 1, [sitting]27 = 1, [sitting]56 = 1), 1, 0)
Thanks this helped....
Hi community i'm trying to create a formula that calculate a sum in a column based on may criteria. here is a screenshot of the affected column i want to calculate the "volume cumul" (sum of volume collected) based on Week Active should be "This Week" or "Next Week" same Unique ID should be calculated together if Unique ID…
Hi I am trying to work out a percentage for some KPIs. I have a sheet I am recording various KPI entries on (see below) I have a metrics sheet set up so, I can break the KPI results down by month by referencing this sheet. Taking KPI 1 (in the example shown above), I need a formula that will return a percentage of the…
Hi all, Is it possible to display some sort of graphic like this within a dashboard? I'd be taking data from a form and gathering total numbers of of "yes" and "non" questions to get the numerator and denominator for each row or column in the picture. I think I could do the metric sheet part of this task no problem, but…
