Formula calculation to find percentage calculation of one location from 5 different locations which
Options

VPMO
✭✭
Formula calculation to find percentage calculation of one location from 5 different locations which are not older than last 30 days, which shows the result as "#Unparseable "
=ROUND(COUNTIF(City:City, "A") / (COUNTIF(City:City, "A") + COUNTIF(City:City, "B") + COUNTIF(City:City, "C") + COUNTIF(City:City, "D") + COUNTIF(City:City, "E") + COUNTIF(City:City, "F")) * 100, 2 ,(Reported:Reported, >=TODAY(-30)),
Answers
-
Ignoring the ROUND function, I think what you're looking for is:
=COUNTIFS(City:City,"A",Reported:Reported,>=TODAY(-30))/COUNTIFS(City:City,OR(@cell="A",@cell="B",@cell="C",@cell="D",@cell="E"),Reported:Reported,>=TODAY(-30))
-
I will try it out. Thanks Philip!!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!