Can anyone come up with a way to reference the cell to the immediate left of the current cell without having to specify the column name to the left?
@Rob Oaks , what are you trying to accomplish that requires you not to reference the column name?
I have about a dozen pairs of alternating %/Hours columns as show below. The Hours column formula always referes to the % column formula to its left. They are all configured as column formulas.
I was hoping to just use the same column formula in all of the Hours columns.
Silly me, however, as I just realized that I could just create a cell formula in the first Hours column, copy it to the other Hours columns, and _then_ convert them all to column formulas. In that way, the % column references, which are relative, are automatically updated as I copy.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I have several grid sheets that have SUMIF summary formulas running. I’m working on a new sheet that requires I split the date & time that are included in one column. Summary formulas I would ordinarily run on the Program Start Date no longer work. Am I correct in assuming the summary formula will not operate on a column…
On my Smartsheet, I want to count the number of lots manufactured per year based on the date of manufacture. If the date is between 1/1/2023 and 12/31/2023, give me a value of "2023", and the same moving forward in 2024 and so on. I cannot figure out what the formula will be. Can someone please advise? Thank you in advance.
I'm looking to put together a formula that outputs a status based on a few criteria. This formula should output "Denied" by default. If the [Price] is $500 or less and [ManagerApproval] = "Approved", output "Confirmed". If the [Price] is more than $500 but less than $1000 and [ManagerApproval] = "Approved and…
©2024. All Rights Reserved Smartsheet Inc.