It would be amazing if we had the ability to refer to other fields. For example if I have an item in a field at ITEM level, and need to replicate that at subitem level - but if it changes at item level the subitem will change as well. So I guess being able to mirror items within the same boards, different item levels and use them in formulas.
Hey @samjtaylor
We developed an app that solves this exact pain point of subitems inherting column value from parent. It’s called Subitem Automations and it allows to do this on subitem creation and when the parent item changes, here’s an example -
On creation - Populate item’s data into its subitems in a seamless way
On change - Being able to set dependency between a subitem to an item
You can find it in the monday.com marketplace in the platform or here - monday.com: Apps Marketplace
Hope that helps!
1 Like
Hi Sam,
I know that’s not necessarily what you’re looking for, but with the Advanced Formula Booster, you can create formulas that involve any type of items.
For instance, if you’re in the master board, you may create formulas prefix your column with Sub, Previous, Next, GroupItems, BoardItems, Board2Items, Board3Items. Let’s say you have a Date column at the item and sub-item levels:
{Date} refers to the date column of the current item
{Sub.Date} refers to the date column of the sub-items
{Sub.Date#1} refers to the date column of the 1st sub-item (as an example)
{Parent.Date} refers to the date column of the parent of a sub-item (when creating a formula in the sub-item board)
{Next.Date} refers to the date column of the next item
{Previous.Date} of the previous item
{GroupItems.Date} of all the items in the same group as the current item
{BoardItems.Date} of all the items in the same board
{Board2Items.Date} of all items in another board of your choice
{Board3Items.Date} of all items in another board of your choice
For instance, if you write a formula with this syntax:
{Sub.Date}={Date}
It will copy the date of the current item to all sub-items.
Thanks to this, you can read or update any column of any item - It is important to say that the Advanced Formula Booster does not use the formula column, but rather casts formula results to the column of your choice (any column of any item).
AFB provides a number of functions to manipulate lists of values. For instance,
{Sub.Date} returns all the dates of the sub-items. If you wish to write the most recent date to the parent item, you would create a simple formula that reads:
{Date}=MAX({Sub.Date})
The documentation can be found at https://docs.mdboosters.com. Use-cases at https://blog.mdboosters.com.
Hope it helps.