Is there a suitable replacement for the AND formula we would have used in excel? I've tried to add AND, and it goes blue and seems okay, until clicking apply, then it just states that And is not a valid function.
Essentially i have more than 2 parameters in my If statement, and was thinking perhaps ';' could work as it's similar.
Essentially im trying to create a productivity trend for different markets, but each market has a different billable number, meaning each market has a unique parameter. MEaning German team cold be Captured time/(days worked*420 minutes a day* billable for 10 people). But i have several markets to do this with, and just want to use 1 line graph to project this when selecting that markets button, i can do for overall, and per city but not per market.