Formula for Calculating percentage in rows

Please below is a dummy example and I need the formula for finding the population percentage so that I can apply the same formula to other rows by clicking and dragging to auto-fill.

Countries Total #of Men Total # of Women Total # of Children Total Population Population in %

Canada 345000 456000 567000 1368000 what is the %?

Best Answer

  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭
    edited 03/21/22 Answer ✓

    Hi @daoppong,

    Just create columns of % with formulas in each column as below screenshot:

    % Men : =[Total #of Men]@row / [Total Population]@row

    % Women : =[Total # of Women]@row / [Total Population]@row

    % Children: =[Total # of Children]@row / [Total Population]@row

    Gia Thinh Co. - Smartsheet Solution Partner.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!