Modify display name for "Progress" column type?

Hi everyone,

Is there a work around to change the display name for the "Values " in a Progress column type?
I would like this to show other words.
3X_8_f_8f6be87859301cf1860a8162c287f6b851105a36.png

Solved Solved
0 2 1,083
1 ACCEPTED SOLUTION

Please explore following workaround.

  • Create a new enum column called say [Progress 2] with values as you want. Say you wish to show values as per the table below against the standard values of Progress column.
  • Retain the original progress column and its original values as well

3X_8_8_88a60c259bc5fb9df17701d26119b741b7873c37.png

  • In the App formula of Progress column , please have an expression

IFS([PROGRESS 2]=โ€œZeroโ€, โ€œEmptyโ€,[PROGRESS 2]=โ€œLittleโ€, โ€œQuarterโ€, [PROGRESS 2]=โ€œSignificantโ€, โ€œHalfโ€,[PROGRESS 2]=โ€œVery Goodโ€, โ€œThree Quarterโ€,[PROGRESS 2]=โ€œExcellentโ€, โ€œFullโ€)

  • In the Show_if of Progress column, you may have something like
    OR(CONTEXT(โ€œViewTypeโ€)=โ€œDetailโ€, CONTEXT(โ€œViewTypeโ€)=โ€œTableโ€)

  • In the Show_if of Progress 2 column, you may have something like
    CONTEXT(โ€œViewTypeโ€)=โ€œFormโ€

The approach assumes, the user updates progress column through form view. You may needs to change suitably depending on how the progress column is updated in your app.

Edit: Minor changes in description

View solution in original post

2 REPLIES 2

Please explore following workaround.

  • Create a new enum column called say [Progress 2] with values as you want. Say you wish to show values as per the table below against the standard values of Progress column.
  • Retain the original progress column and its original values as well

3X_8_8_88a60c259bc5fb9df17701d26119b741b7873c37.png

  • In the App formula of Progress column , please have an expression

IFS([PROGRESS 2]=โ€œZeroโ€, โ€œEmptyโ€,[PROGRESS 2]=โ€œLittleโ€, โ€œQuarterโ€, [PROGRESS 2]=โ€œSignificantโ€, โ€œHalfโ€,[PROGRESS 2]=โ€œVery Goodโ€, โ€œThree Quarterโ€,[PROGRESS 2]=โ€œExcellentโ€, โ€œFullโ€)

  • In the Show_if of Progress column, you may have something like
    OR(CONTEXT(โ€œViewTypeโ€)=โ€œDetailโ€, CONTEXT(โ€œViewTypeโ€)=โ€œTableโ€)

  • In the Show_if of Progress 2 column, you may have something like
    CONTEXT(โ€œViewTypeโ€)=โ€œFormโ€

The approach assumes, the user updates progress column through form view. You may needs to change suitably depending on how the progress column is updated in your app.

Edit: Minor changes in description

Amazing! you should put this under Tips and Tricks.
I believe it is very useful.

Thanks @Su

Top Labels in this Space