Skip to main content

Display Percent of Goal Complete in Interface

  • February 14, 2023
  • 3 replies
  • 27 views
M
Forum|alt.badge.img+1

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

3 replies

TheTimeSavingCo
Forum|alt.badge.img+28

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

 
Adam, Consultant @ thetimesaving.company
D
Forum|alt.badge.img+4
  • DannyAWyatt
  • Inspiring
  • 7 replies
  • February 15, 2023

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
Forum|alt.badge.img+13
  • Vic_Airtable
  • Participating Frequently
  • 102 replies
  • June 15, 2023

Hi @DannyAWyatt 

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

Reply


Most helpful members this week

Terms & Conditions