Is there a way to do any of the following? (Without paying for other apps)
copy a formula result to another column from a formula column in a subitem?
Or alternatively - is there anything like General Caster that works at the subitem level?
Or a way to pull a start and end date from a subitem timeline column into a date column
I would need to do this with a free app or in Monday natively. My client does not have funds/approval for things like Make, Zapier or the paid apps that separate dates from timelines.
Use case: I have 2 formulas that pull dates from timelines for me, I need to calculate the days between those two dates but I can’t run a formula on formula results, and I can’t use General Caster on subitems. I’ve been looking at Column Magic, Autoboost, Vlookup, Subitem Automations and Formulas in Automations but can’t seem to find a fix.
Thanks!
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
2
Hi Sara,
You may want to look at the Advanced Formula Booster.
With it, among many other things, you can copy the content of a sub-item column to the parent or create formulas using sub-item columns (or parent columns if you write the formula from a sub-item).
When you write a formula at the sub-item level, you have access to all the columns of the parent, using the Parent. prefix. For instance, to copy the content of the {Date} column of the sub-item to the parent, the formula would be:
At the item level, you have access at all the sub-items using the Sub. prefix. So for instance, this formula copies the date of sub-item #1 to the Item’s Start Date:
The formula above can be modified in a number of ways to dynamically look for the sub-item you want to copy to the parent (in case it is not always #1).
Another thing you can do is use a function like MIN or MAX particular useful for dates. The following formula retrieves the earliest date among all sub-items and copies it to the item’s start date.
Of course, you can use formulas that are a lot more complex.
If you need any help, there is a ticket system within the app itself. Simply open a ticket and you’ll receive all the help you need to quickly set up your formulas.
They have two recipes for subitems currently but it looks like they are also working on an app specifically for subitem formula automations. They also have an app for Mirrors(parent item only) and a specific app for converting timelines and dates. Quite impressed with PickApps!
