Skip to main content
Question

How do I display a calculated column on my Summary Report?

  • June 18, 2018
  • 0 replies
  • 42 views
How do I display a calculated column on my Summary Report? I have a calculated column with a text formula, I have <calculated column> selected, but it won't display. Also potentially related is that fact that all of my columns are listed as numeric, even "addresses" that are an address type field. New user here, thanks!
    This topic has been closed for replies.

    • GauravSharma3
    • Quickbase Alumni
    • June 19, 2018
    Hi, what are you trying to calculate through that field?

    Thanks,
    Gaurav
    • CMHQBCMHQB
    • Author
    • Quickbase Alumni
    • June 19, 2018
    I'm trying to display the text to be written on a wedding invitation. The formula checks if they have a +1, whether their last names are the same, etc. See below:

    If([Is a +1?]=null,If([Bringing a +1?]=null,[First Name]&" "&[Last Name],If([Last Name]=[+1 Last Name],[First Name]&" & "&[+1 First Name]&" "&[Last Name],[First Name]&" "&[Last Name]&" & "&[+1 First Name]&" "&[+1 Last Name])),null)
    Terms & ConditionsAccessibility statement