# Make drop-downs reflect an in table % of completion (rectangle) **URL:** \ **Category:** Ask the Community\ **Created:** [July 23, 2019, 7:58pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374 "2019-07-23T19:58:04Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Curtis\_Smith](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/curtis_smith/32/7918_2.png) [@Curtis\_Smith](https://connect.superhuman.com/u/Curtis_Smith)\ **Post date:** [July 23, 2019, 7:58pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/1 "2019-07-23T19:58:04Z")
Please take a look at the image below. I would like to emulate the total progress based off of the drop downs. Its unique in that each drop down has different selectors each representing forward progress. Example: If CV is marked “Go” thats 34% because its the only option But in Phone Interview, there is the option of “scheduled”, “Go” “Call Again”, Scheduled would move it forward 17% (total progress = 51%) and “Go” would move it forward 34%. (total progress 68%) Call Again would negate the total progress and the toal would be back at 34% Does that make sense? ![19%20PM](https://global.discourse-cdn.com/coda1/original/2X/9/923ef548487515871fa55709469353bb33a0653c.png) ---
**Author:** ![Kurt\_Kessler](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/kurt_kessler/32/5754_2.png) [@Kurt\_Kessler](https://connect.superhuman.com/u/Kurt_Kessler)\ **Post date:** [July 23, 2019, 8:13pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/2 "2019-07-23T20:13:42Z")
So there is another secondary table that contains the selectors for CV, Phone Interview, Personal Interview? Or does each field just have the choice of “Blank”, “Scheduled” or “Go” ? ---
**Author:** ![Curtis\_Smith](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/curtis_smith/32/7918_2.png) [@Curtis\_Smith](https://connect.superhuman.com/u/Curtis_Smith)\ **Post date:** [July 23, 2019, 9:54pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/3 "2019-07-23T21:54:04Z")
Thanks for responding. Let me know if this helps to answer your question. ![showing](https://global.discourse-cdn.com/coda1/original/2X/2/22b320c90bbf2f0945c6b8fb429cfeb67e1eea70.gif) ---
**Author:** ![Kurt\_Kessler](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/kurt_kessler/32/5754_2.png) [@Kurt\_Kessler](https://connect.superhuman.com/u/Kurt_Kessler)\ **Post date:** [July 24, 2019, 12:08am UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/4 "2019-07-24T00:08:40Z")
Well…I would have the “choices” in another table that you would do a lookup to. In that secondary table, give each choice a numeric level. If the CV field only has “Go” or “No Go” has choices, I would give the “Go” a level of 34% and “No Go” a level of 99. The Phone Interview field would have “Go” = 67%, “No Go” = 99, “Scheduled” = 51%, “Call Again” = 34% The Personal Interview field would have “No Go” = 99, “Scheduled” = 84%, “Go” = 100% This way assumes that there are no new levels added / subtracted later. If so, you would have to adjust the numeric levels. I don’t have the algorithm down pat, but if the level is 99, then game over and progress is either 0 or 100% depending on how you look at it. You could have a Total Progress field with something like `concatenate(Rectangle(min(100,max level * 100),15,"#00ff00","Progress"),rectangle(100-( max level*100),15,"#838b83", " "))` Make sense? ---
**Author:** ![Curtis\_Smith](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/curtis_smith/32/7918_2.png) [@Curtis\_Smith](https://connect.superhuman.com/u/Curtis_Smith)\ **Post date:** [July 24, 2019, 6:54am UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/5 "2019-07-24T06:54:01Z")
This is great. Can you please clarify…when you say give numerical value do you mean in one column would be “Go” and in column two would be the percentage? ---
**Author:** ![Curtis\_Smith](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/curtis_smith/32/7918_2.png) [@Curtis\_Smith](https://connect.superhuman.com/u/Curtis_Smith)\ **Post date:** [July 24, 2019, 8:55am UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/6 "2019-07-24T08:55:36Z")
The progress bar doesn’t work. ---
**Author:** ![Kurt\_Kessler](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/kurt_kessler/32/5754_2.png) [@Kurt\_Kessler](https://connect.superhuman.com/u/Kurt_Kessler)\ **Post date:** [July 24, 2019, 1:23pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/7 "2019-07-24T13:23:22Z")
Yes. That’s exactly what I mean. I apologize for not being clear. ---
**Author:** ![Curtis\_Smith](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/curtis_smith/32/7918_2.png) [@Curtis\_Smith](https://connect.superhuman.com/u/Curtis_Smith)\ **Post date:** [July 24, 2019, 1:27pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/8 "2019-07-24T13:27:22Z")
BARS EXIST BUT I DON’T THINK THEY ARE LINKING TO THE DROP DOWNS. https://coda.io/embed/gz5pLsKQ20/_suXum?viewMode=embedplay ---
**Author:** ![Daniel\_Stieber](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/daniel_stieber/32/17045_2.png) [@Daniel\_Stieber](https://connect.superhuman.com/u/Daniel_Stieber)\ **Post date:** [July 24, 2019, 1:59pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/9 "2019-07-24T13:59:55Z")
You can also use ‘Scale’ to create a kind of progress bar. There logic behind the percentage is very basic here, maybe you can automate the amounts by counting the elements. But I think you have to define thinks like the number of columns anyway, so it probably doesn’t really matter. The formula of the progress bar checks each column value and looks for the percentage value in the steps table. You have to check, if the field is empty, otherwise you’d get an error. In the end it is rouneded up, so 9.9 (33,33 \* 3) will result in 10 https://coda.io/embed/vvluQILckl/_suaCo?viewMode=embedplay And of course this here is a great example for reactangle progress bars, where you can probably apply my logic too: > [@Multipart progress bar from table rows](https://connect.superhuman.com/t/multipart-progress-bar-from-table-rows/7484): > > One thing I particularly love about Coda is that it lets me quickly build simple productivity tools to help me with my mess of a life. Just now I was thinking of building a “where did my time go” tracker. I wondered if it was possible to visualize my day as a multipart progress bar with work, break, and procrastination periods as differently colored sections (interleaved, not aggregated). Yep, it’s possible! You can use .FormulaMap(Rectangle(…)).Concatenate() on a list of rows to get a nice con… ---
**Author:** ![Curtis\_Smith](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/curtis_smith/32/7918_2.png) [@Curtis\_Smith](https://connect.superhuman.com/u/Curtis_Smith)\ **Post date:** [July 24, 2019, 2:05pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/10 "2019-07-24T14:05:55Z")
Thanks guys. I really appreciate the help! ---
**Author:** ![Curtis\_Smith](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/curtis_smith/32/7918_2.png) [@Curtis\_Smith](https://connect.superhuman.com/u/Curtis_Smith)\ **Post date:** [July 24, 2019, 2:13pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/11 "2019-07-24T14:13:12Z")
How would be able to have blanks exist? I need them for the UX ---
**Author:** ![Daniel\_Stieber](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/daniel_stieber/32/17045_2.png) [@Daniel\_Stieber](https://connect.superhuman.com/u/Daniel_Stieber)\ **Post date:** [July 24, 2019, 2:18pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/12 "2019-07-24T14:18:20Z")
I just used a basic “if”. dummy code: if(thisrow.cv.isnotblank(), _you formula to add value for column cv to the bar_, 0) That way, a column (e.g. cv) without blank value will result in a 0 in your calculation and doesn’t mess it up. ---
**Author:** ![Kurt\_Kessler](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/kurt_kessler/32/5754_2.png) [@Kurt\_Kessler](https://connect.superhuman.com/u/Kurt_Kessler)\ **Post date:** [July 24, 2019, 3:29pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/13 "2019-07-24T15:29:55Z")
Curtis, I shared a doc with you that should resolve your issues. Let me know if you didn’t get the share. ---
**Author:** ![Curtis\_Smith](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/curtis_smith/32/7918_2.png) [@Curtis\_Smith](https://connect.superhuman.com/u/Curtis_Smith)\ **Post date:** [July 24, 2019, 5:25pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/14 "2019-07-24T17:25:53Z")
No share on my end Kurt ---
**Author:** ![Kurt\_Kessler](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/kurt_kessler/32/5754_2.png) [@Kurt\_Kessler](https://connect.superhuman.com/u/Kurt_Kessler)\ **Post date:** [July 24, 2019, 5:39pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/15 "2019-07-24T17:39:58Z")
[curtis.smith@celo.org](mailto:curtis.smith@celo.org) right? ---
**Author:** ![Curtis\_Smith](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/curtis_smith/32/7918_2.png) [@Curtis\_Smith](https://connect.superhuman.com/u/Curtis_Smith)\ **Post date:** [July 24, 2019, 6:11pm UTC](https://connect.superhuman.com/t/make-drop-downs-reflect-an-in-table-of-completion-rectangle/9374/16 "2019-07-24T18:11:31Z")
Correct. let me go double check. one sec.