Forum Discussion

CasieMasters's avatar
CasieMasters
Qrew Cadet
7 years ago

How to get the data from a summary field and populate a formula field

I have summary fields that need to be color coded.  I am thinking I need to create a formula rich-text field and have the formula read for it to equal whatever value is in the other field, then create...
Tables and fields
CasieMasters's avatar
CasieMasters
Qrew Cadet
7 years ago
Thank You!  How do I get the formula field to get the value from the summary field to populate though?  Then I can hide the summary field and just have my report populate my colored (formula) fields. 
  • QuickBaseJunkie's avatar
    QuickBaseJunkie
    Icon for Qrew Legend rankQrew Legend
    7 years ago
    How did you create your summary field? Is it just in a Summary Report or is it an actual summary of child records in a relationship?

    In the method I described above you would use a summary field from a relationship. Summary reports don't allow for colorization.

    In my example "[Priority]" refers to the Summary field, so you'd just replace it with your summary field name.