Formula for % Complete
Looking for a sample formula that will allow me to multiply by the "% Complete" column in a sheet
Best Answer
-
Replace the number 16 with the word row
=[Build Hours]@row * [% Complete]@row
Answers
-
Are you able to provide more context?
Have you tried this yet?
=[Number Column Name]@row * [% Complete Column Name]@row
-
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.
-
Replace the number 16 with the word row
=[Build Hours]@row * [% Complete]@row
-
Aha! I thought I had to specify a row number. Thanks for the correct syntax Paul, your help is much appreciated!
-
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
-
Very helpful, thanks again.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives