Formula for % Complete

Jennifer Stenekes

Looking for a sample formula that will allow me to multiply by the "% Complete" column in a sheet

Paul Newcome

Replace the number 16 with the word row

=[Build Hours]@row * [% Complete]@row

Paul Newcome

Are you able to provide more context?

Have you tried this yet?

=[Number Column Name]@row * [% Complete Column Name]@row

Jennifer Stenekes

Here's a screenshot:

I think it may not like that the %complete column is a percentage. The cell type for both "build hours" and "% complete" is text/numbers so seems like it should work.

Paul Newcome

Replace the number 16 with the word row

=[Build Hours]@row * [% Complete]@row

Jennifer Stenekes

Aha! I thought I had to specify a row number. Thanks for the correct syntax Paul, your help is much appreciated!

Paul Newcome

Happy to help. 👍️

The only time you need to specify a row number is if the formula is referencing a cell on a different row from itself (e.g. formula is on row 16 but you want to reference row 14).

In that case it would be written without the @ and just have the row number.

=[Build Hours]14 * [% Complete]14

Jennifer Stenekes

Very helpful, thanks again.

Jennifer Stenekes