@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

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
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…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.