Jump to content
  • 1

Ability to do simple calculations in tables


Mike Vila

Idea

Posted

I would love to switch from my complicated spreadsheet software to do simple calculations. Can you please add the ability to do SUM and other simple calculations in Evernote tables, please.

  • Like 1

8 replies to this idea

Recommended Posts

  • 0
  • Level 5
Posted

Maybe they can. Probably they can't. We don't know. 

If you search the forum, you will find a feature request thread going back some years, asking for this. It is drawing votes, but up to now, calc in tables has not materialized.

Maybe add your vote there as well.

And to the topic: I agree, missing a quick sum or count as well. Workaround is to put the table into a spreadsheet, and nest it into the note.

  • 0
Posted

Thanks for responding PinkElephant. I did a search for 'table calculations' but nothing came up so I posted this. I tried to vote but it won't let me vote on my own request. I don't see a way to nest a spreadsheet. I can drag and drop the file, but not nest the actual Apple Numbers spreadsheet?

  • 0
  • Level 5
Posted

It sort of depends on your client.

The Mac desktop client can only open the numbers file, not show it inline. The Windows desktop client doesn't even know something like Numbers exist ...

The iOS client can open the numbers file for display, but won't change it. Or it can open the file for editing, but not save it back to the same note.

So no, it is not the same as a table in EN that would do its own math.

  • 0
Posted
On 6/17/2022 at 3:56 PM, Mike Vila said:

I would love to switch from my complicated spreadsheet software to do simple calculations. Can you please add the ability to do SUM and other simple calculations in Evernote tables, please.

Evernote! Can you please add the ability to do SUM and other simple calculations in Evernote tables, please!!!
Tell us when, we will wait patiently. Please, answer us. 
 
 
 
 
  • 0
Posted

The ability to embed a spreadsheet into a note is now available for all users.

  • 0
Posted
On 4/5/2024 at 8:38 AM, Mike P said:

The ability to embed a spreadsheet into a note is now available for all users.

@Mike P I'm able to embed them, but then how does one make the calculations added in Excel to "continue calculating" inside Evernote as one edits the values either inside Evernote or back in Excel? Right now, every time I bring an Excel doc into Evernote, it drops a non-editable embed in the note, but more like a flat image. If I change values inside columns A and B, the sums in column C don't refresh, and neither does changing the values in Excel will refresh the embed inside Evernote. Help! 🙂

Screenshot 2025-01-04 at 8.53.35 AM.jpg

  • 0
Posted
On 1/4/2025 at 12:55 PM, M3Orange said:

@Mike P I'm able to embed them, but then how does one make the calculations added in Excel to "continue calculating" inside Evernote as one edits the values either inside Evernote or back in Excel? Right now, every time I bring an Excel doc into Evernote, it drops a non-editable embed in the note, but more like a flat image. If I change values inside columns A and B, the sums in column C don't refresh, and neither does changing the values in Excel will refresh the embed inside Evernote. Help! 🙂

Screenshot 2025-01-04 at 8.53.35 AM.jpg

By embedding the file you are creating a new copy of the file. Changing the original file will not change the file embedded into EN

You cannot change the values directly in EN.

To update the file you need to open it (e.g by double clicking the gray header area) and then change it in Excel. Saving the file will then update the file in EN and the preview should change.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...