Looking for a sample formula that will allow me to multiply by the "% Complete" column in a sheet
Replace the number 16 with the word row
=[Build Hours]@row * [% Complete]@row
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.
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.
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.