Mutliple Calculated Formula Columns in a report?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Is it possible to add more than one calculated formula column to a report?


Alternatively, is it possible to add a blank column into a report?


(side info: I am trying to create a report that will be exported to an excel file with pre-defined column headers. Some of the columns match to my QB fields, but other columns are calculated based on the info from the QB fields. This is a large excel file with 100+ columns and I'd like to find an easy way to align the columns when I am building the report)

Photo of Taylor

Taylor

  • 52 Points

Posted 4 years ago

  • 0
  • 1
I would suggest dropping the imported fields into "Sheet 2" and using formulas to put the data into your "Sheet 1".
Photo of Taylor

Taylor

  • 52 Points
This amounts to what I was already doing, which is manipulating/adding new fields once I've exported excel. Does anyone have a suggestion for how to do this in quickbase? I was hoping for something along the lines of the ability to add more than one "calculated formula column".
... well arguably its not manipulating as you would have a standard area to paste your imported data into on Sheet 2, and then Sheet 1 would be all set up with whatever formula fields you need - with no manipulation or adding columns.  But nevertheless, I have treated this as a comment, in case someone else has an answer.  The only other answer I know is in making a bunch of real but dummy fields.
Photo of Eric

Eric

  • 40 Points
To answer your first question, no it isn't possible to have more than one calculated column in a QuickBase report.

For the rest, I recommend creating formula fields on your table to perform the "calculated based on the info from the QB fields" values you want. You may then include these formula fields only on the report you want to export to Excel.