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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives