Change the Max Size for Status Column

[Ross_Tesoriero]

Hello! Is it possible to change the Maximum value for a Scale column?

I want to use the Staffed column to show how many people have been assigned. A Trio should be out of 3, a Quartet should be out of 4, so I want the number of rectangles to adjust.

[Paul_Danyliuk]

Hey.

One solution (simple) would be with drawing some emoji instead of using a progress bar:

Fun solution to variable max scale number

I had someone reach out asking about having the max scale number of a column vary. For example, if the goal is 10 and 2 tasks are completed, you’ll be able to select 2 stars out of 10 selectable, but if the goal in another row is 14, then you have 14 selectable stars. Here’s the solution I came up with, essentially sequencing the values of both the actual number and goal, then using FormulaMap to put an emoji to each value. Feel free to play around with goal vs. actual to see how that changes th…

(note that formulas are incorrect there, Sequence(1, x) goes backwards when x < 1 and draws two items if x = 0.

Another solution would be with rectangles. It’s more complicated to implement, but more flexible (e.g. you can color-code your band members and see team staffing at a glance):

Multipart progress bar from table rows

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…

To think of it, you can use different emoji too. All solutions would require a formula of a sort, so just see what’s easier for you / good enough.