Display Percent of Goal Complete in Interface

[madavilla]

Hi, is there any way to display on the interface a result from a formula?

I am trying to track how many contracts we have signed for the month and year against the goal for the month and year and then display the percentage of goals complete and the remaining amount to the goal.

For example, we have 52 contracts signed so far this month, but the goal is 360 for the whole year. How do I show the percentage of goal complete and the remaining contracts we need?

Is there any way to display that on the interface?

Thanks!
Miguel

[TheTimeSavingCo]

I think you're going to need a table set up purely for you to format your data I'm afraid.   Link all your contracts to a single helper record in another table, and display your % value from that record:

Link to base

Alternatively you can ensure you maintain 360 records in your "Contracts" table and fill them out individually when they're signed, but that's a...pretty weird workflow and probably not desired

[DannyAWyatt]

Hey there, actually I have been wondering the same thing since the List View announcement

It seems like they have a progress bar element that is not mentioned in the article. I'm super keen to understand more as this would be a huge lift in some of the interfaces, depending on the logic it operates on. 

[Vic_Airtable]

Hi @DannyAWyatt 

Check out this Community announcement for more information on the Progress bar for percent fields.