I’m creating a chief board for my c-suite team to be able to follow different projects/campaigns.
One of their wishes is to have an active Revenue/Time spent calculator. What I want to do is to time track different parts of a project, mirror all of them together in their chief board item related to that project, and divide the revenue from that project with the time tracked (spent.)
I tried most options I could think of, like just doing {Revenue}/{TimeTracker}, Divide({Revenue}, {Timetrack}). I also tried with the {Timetrack#Hours}.
Anybody know where the problem lies? Is the problem in the fact that it mirrors the sum of many timetrackers?
Best regards,
Stjepan Palada
ARCH. Influencer Agency
Based on your description, I’ve made this loom for you to show both what happens when you mirror a time tracking column directly into another board and try to use it for formulas versus the workaround I think you can use instead!
Basically, by making a formula on each board that outputs the {Time Tracking#Hours} , you can have this formula mirrored into your Project Totals board to use as an easy to calculate number your Revenue column can be divided by in order to see the amount of money being paid per hour for that project.
Here is the final formula I showed in the video: ROUND(({Revenue}/{Mirror}), 0)
Does this cover what you were looking to achieve? If not, can you tell me more about what kind of formula you are trying to build and what exactly is being mirrored?
I hope this helps! Remember to mark as solved if this answers your question
Hey @jennap,
first of all, serious kudos for going above and beyond to actually even shoot a video just to help out a client. Cheers.
Sadly, however, while all that you shown was correct and your assumptions were on point, I still do not get what happens. I did everything as shown in the video, but I get the same error as before:
Perhaps there is some obvious mistake that I am making that I am too deep to notice now, but this is the outcome I get.
Shoot! There are currently limitations with Multi-board mirroring, including the fact that The Formula Column isn’t officially supported, which is likely why it worked for me but shwed an error for you.
While definitely not ideal for the time being, as the message you’ve seen says, this is something we’re working on officially supporting, so stay tuned! You can keep up to date with all of our new features by clicking on either of the Present Icons:
In the meantime, you can always try using something like the General Caster app to take information from the formula column and have it input into something that, which is supported in multi-board mirroring!
Since we don’t have an ETA on when the formula column will be supported on it’s own, you’re free to try this as an extra workaround if that helps!
Do note that General Caster was not developed by the monday.com team. As such, we don’t have any control over its functionality – and do not provide support for setting it up. Our team has reviewed it against our security and privacy guidelines, but we cannot fully certify it.
If you do want to try it out, I’d recommend checking out the app details in the marketplace here: The monday apps marketplace . You can review the app’s documentation (and applicable privacy policies) and install it if you choose.
It is specifically designed to be used for top-level or C-level boards. It aggregates all kind of columns form lower-level (Project) boards without mirroring. Mirroring on itself is very useful in many use cases but for C-level reporting you probably do not want to give the C-level the ability to change data in the Project board through the mirror. See this Loom for a short 5 minute demo.
