Sheet Column References in Equations

Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever number is put in for "x", will add to the column length that sum equation is good for, however when I try to do this, I get the error back. Right now I have:

=SUM[PREV BILLINGS]2:[([JAN-18]2)+($Type$165)]2

where the "Type165" references the number to input for "X". "PREV BILLINGS" and "JAN-19" are current Column names. Any help is appreciated, thank you.

Find more posts tagged with

Templates

Construction

Sheets

Finance

Formulas

Reports

Solution Center

Project Management

Comments

Robert S.

Hello,

Thanks for the question. We don't currently have a way to convert a column reference to a number. I recommend using the "Submit Product Enhancement Request" link in the Quick Links section to the right, to submit your vote for this feature for future product development.

That being said, it's possible that there may be another way to do what you're looking to do, however I'm not sure I completely understand what that is. If you can provide some more detail on what you'd like, or even a screenshot to help illustrate what you're looking for, I'll be happy to take a look.

Sign in to join the conversation!

Quick Links

Trending discussions

Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
Nested IF Statements
Hello. I cannot figure this out. =IF([GL Code]@row = 14030, "Leasehold") How do I add additional IF statements in the same cell, for example if the GL Code@row = 14040, "FF&E", GL Code@row = 14050, "CR Equip" Thanks.