Skip to main content
Answered

Use basic formulas within tables

  • November 23, 2020
  • 4 replies
  • 13656 views

I would like the ability to run basic formulas like SUM, AVERAGE, etc within a table. I want to use Miro for our Real Estate projects, to understand the processes, staff and costs involved. We will use tables a lot, but currently we see that we canโ€™t create basic SUM formulates of cells.

Best answer by Robert Johnson

@Enrique Lopez - Miro Grids, aka, tables, do *NOT* support formulas. Instead, you may want to explore using Google Sheets or Excel files and either embed the in the board as links using the Google Drive or OneDrive app in Miro.

The following Miro Help Center articles will have more information on how to do this:

If you would like to see formulas as an options in Grids, Iโ€™d recommend adding this as an Idea in the Wish List category by following the guidelines here: Wish List: Everything You Need to Know. If you do create a Wish List Idea post, I would also recommend that you post a link to it back here, so that future readers of this post can quickly get to and vote for your Idea.

*updated!

View original
Was it helpful?
36% found this helpful
This topic has been closed for comments

4 replies

Robert Johnson
Forum|alt.badge.img+13
  • Volunteer Community Moderator
  • 7289 replies
  • Answer
  • November 23, 2020

@Enrique Lopez - Miro Grids, aka, tables, do *NOT* support formulas. Instead, you may want to explore using Google Sheets or Excel files and either embed the in the board as links using the Google Drive or OneDrive app in Miro.

The following Miro Help Center articles will have more information on how to do this:

If you would like to see formulas as an options in Grids, Iโ€™d recommend adding this as an Idea in the Wish List category by following the guidelines here: Wish List: Everything You Need to Know. If you do create a Wish List Idea post, I would also recommend that you post a link to it back here, so that future readers of this post can quickly get to and vote for your Idea.

*updated!


Brian Fulghum
Forum|alt.badge.img+1
  • Experienced Community Member
  • 67 replies
  • November 25, 2020

@Robert Johnson , did you mean to say they do NOT support formulas? After reading your comment I went looking for how, but canโ€™t find it.

But I found that Google Sheets works fine, can be edited from inside MERO (albeit a bit slowly), and once edited inside Miro, saved updates in Google Drive. Amazing integration!


Robert Johnson
Forum|alt.badge.img+13
  • Volunteer Community Moderator
  • 7289 replies
  • November 25, 2020

@Brian Fulghum - Yes, good catch! I have updated my reply.


Thanks to both, for now I will try to understand the Google Sheets integration. Thank you again.