Hi everyone! Is there any way to add a max limit of points at the bottom of this column to the “sum” cell? The idea is I have 40 points in total per week, and need to make sure we don’t exceed when assigning points to projects. Thanks!
Hi Victor,
You’ll find there isn’t much data validation in monday.com natively.
Additionally, that summary is really just a summary. It isn’t usable data and the potential to interact with it is limited.
For this kind of functionality, I’d recommend using subitems for the individual entries and then summarizing them into the parent item. At that point you could apply a formula to the sum value. (Alternatively, you could achieve this by linking the individual values to a single item on a board that stored “weekly” data).
MIN(
{Sum of Points},
40
)
That will allow you to only show a maximum of 40 points, however it won’t prevent you from inputting or create any kind of warning. An option there could be to set a filter or use custom formatting to highlight entries where the value exceeds 40.
Some of the above suggestions might seem odd or surprising. monday.com can seem idiosyncratic if you’re used to using spreadsheets. It’s worth remembering that monday.com is a database rather than a spreadsheet. This has various implications—it’s typically an advantage because you can expect consistent behavior thanks to the consistent format of records (items) in each board.
Hopefully the above is useful and feel free to reach out if you need more help.