Can tables inside a Loop component do Formulas?

Question

I have inserted a Table in a Loop component to collaborate with others.
At the bottom of the columns in my table that are Type > Number, there are drop-downs offering Sum, Average, calculations. But will this table allow me to create calculated Columns? Right now my "Cost Estimate" column is a manual calculation of the $/hr and # hours columns.

Answer 1

Hi Matthew Scott (Matthew_Scott)")

Greetings!

Thank you for posting in Microsoft Community.

We understand that you have a question about Microsoft Loop possibility of having computation using a formula, let’s work on this together as team to get to the bottom of this.

You can use formulas in tables inside a Loop component, but only for some basic calculations such as sum, average, count, min, and max. You can access these formulas by clicking on the drop-down menu at the bottom of each column that has a number type.

However, if you want to create calculated columns based on other columns, such as your "Cost Estimate" column, you will need to use a different tool. One option is to use Excel Online, which allows you to create and edit spreadsheets in your browser and collaborate with others in real time. You can insert an Excel Online spreadsheet into a Loop component by copying and pasting its link. This way, you can use all the powerful features of Excel, such as formulas, functions, charts, and pivot tables.

We look forward to your reply.

Sincerely

Juhn Jac

Microsoft Forum Moderator

Answer 2

Hi Matthew Scott (Matthew_Scott)")

We haven't heard from you in 72 hours, so we assume your issue has already been resolved. We will not be tracking this topic going forward, therefore, if you need further assistance, please create a new topic to discuss these concerns by clicking on this link: Create a new question or start a discussion (microsoft.com)

Sincerely

Juhn Jac      

Microsoft Forum Moderator

Answer 3

I have tried this way, but it does not update if I update in it excel or vise versa. Any tips?

Answer 4

Hi Juhn Jac,

Will this be implemented?

I can see that Loop Tables can be converted to Excel sheets. I find this very useful for collaborative work and I think it would be great to get more seamless excel formula (basic formulae) implemented in Loop tables

BR

Raghul

Answer 5

Loop wouldn't have to replicate the full capability of Excel, but being able to add cells from two columns and having the result be put in a third column would be helpful. Not being able to do simple math misses an opportunity to use Loop tables.