Formula column problems when mirroring "time tracking" column

Hi everyone!

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

Hey @PaladaARCH :wave:

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 :slight_smile:

Cheers,
Jenna

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:
Screenshot_4

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.

Best,
Stjepan

Hey @PaladaARCH :wave:

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.

To learn more about security in the monday apps marketplace, check out this article: Understanding apps marketplace security

You can also contact @rob from the General Caster team for any questions you have about the app!

I hope this helps! Remember to mark as solved if this answers your question :slight_smile:

Cheers,
Jenna​

1 Like

hi @PaladaARCH

Another option is to use this app from the marketplace, monday.com: Apps Marketplace

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.

@jennap @PaladaARCH Just a quick note. Due to its “client-side” nature, native Formula column is not supported in General Caster.
You must convert, if needed, the formula into the syntax accepted by General Caster, then you can rid of the Formula column totally.
https://generalcaster.app/website/documentation/formula/#differences

Hi @rob :wave:

Thanks so much for that helpful addition! This link is really useful :smiley:

Best,

Dani

1 Like

Thanks everyone for the help and suggestions!

We will see how we will work around all of this as we were hoping to make Monday our only tool.

Hopefully, we get multi mirroring support soon. :slight_smile:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.