Add a Progress Bar column type for formula based columns
Need a new column type for formulas to represent progress bars. E.g. in addition to general, number, markdown, add progress.
If possible also adding a new check box that allows for percentages greater than 100 so that we can represent things like benefits where the actuals are greater than the target amount.
Mike
shared this idea
-
Mike
commented
Currently using this formula which is nice but not nice enough...
With Current =
SUM{
Current
}:WITH Target =
SUM{
IF Revised:
Revised
ELSE:
Baseline
}:WITH Width = 10:
WITH Perc = ROUND(NUMBER((Current / Target) * Width, 0), 0):
IF Current & Target:
IF Current > 0 & Perc = 0:
CONCAT("", REPEAT("▄"; 1), "", "", REPEAT(" "; Width-1), "")
ELSE:
IF Perc > Width:
CONCAT("", REPEAT("▄"; Width), "", "", REPEAT("▀"; Perc-Width), "")
ELSE:
CONCAT("", REPEAT("▄"; Perc), "", "", REPEAT(" "; Width-Perc), "")