@Column Reference

I have a formula that I would love to make into a column formula but am unable to because I reference a cell (a helper cell I have in the first cell of the column that is the same as the column name). Without being able to use [column name]1 in a column formula I am unable to have it be a formula that can be easily copied when a new row is added. If we were able to use @Column it would be the same idea as the @Row in a formula.

Sign in to vote!

Find more posts tagged with

Formulas

Enhancement Request

Comments

Andrée Starå

Hi @Sarah123

I hope you're well and safe!

Here's a possible workaround or workarounds

You could maybe reference the cell in a sheet-summary field instead, and then it would work to convert it to a column formula.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sarah123

I'm not sure that would work. I have a column for each resource and then the formula would look up the resources name (right now I have it manually entered into the formula instead of being able to reference the column name) and then the project name. This is the formula:

=IFERROR(INDEX(COLLECT({Hours}, {Resources}, "Resource Name", {Portfolio Project Resources Range 1}, [Project Name]@row, {Status}, <>"Completed"), 1), "")

If I could have the "resource name" updated depending on the column name/title than I wouldn't have to manually update each formula for each column (I have over 100 resource columns).

Alex Kolker

Could we have an @column reference to match the @row reference? It would allow me to use a single formula across an entire row of a sheet (for a SUMIF calculation, for example), rather than having to paste the column header (twice) into the sum range cell by cell.

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…