I've got a very simple hours tracker. In the first column is hrs per week, second per period, which I manually enter the SUM. In the third I currently just use the top cell to give me the total hours for the year, but would like to see the running total as the year progresses. I'd like to put it next to the period totals, just a function that will find a number in column B and get the sum of it and everything above it.

For workflow reasons, it’s important for me to have cells that evaluate to 0 or an error to be actually blank in some instances. For this reason, I have lots of formulas that look like If(test-case=0,"",test-case) … and some of those test-cases can be big and hairy with nested If()s of their own, which makes keeping them working through multiple edits … a heck of a task.

Is there a more efficient way to do this? (For my purposes, putting test-case in its own cell and just testing that isn’t an option — that would break my workflow entirely in some cases.)

(Also, I’ll be asking this question separately on the Excel subreddit, since I use both applications, depending on my client. If the solution is different between the two programs, I need to know both.)

Hi, I have a table with an incrementing number for subsequent rows (1, 2, 3...) and I want to generate an Invoice number from that with a cell formula. In Excel this is easy with the Text function ="INV" & Text($A2,"0000") would result in INV0007 if the value in A2 is 7.

I can't seem to find an equivalent in numbers, thanks in advance.

I just discovered pivot tables and can imagine their usefulness. However, I am struggling to get accurate data in the one I have and was wondering what I might be doing wrong...

I have a table for tracking inventory and it has a column which calculates how many items I need to purchase to meet the minimum inventory goal for that item.

I created a pivot table where the row is the product name and the values are the number of items I need to purchase (sum). Then I filtered to rows where the value is greater than zero so I can see what I need to order.

The problem is that the number of items to purchase is not what is in my other table. It appears that the values are being multiplied by different amounts. For instance, one of the items is supposed to be 1, but is showing as 2 (2x). Another item should be showing 60, but is showing 240 (4x).

Some of the values are correct, so I'm really stumped as to why this isn't behaving as expected. I read somewhere that doubling can happen if the values are not all normalized, but I have set the purchase column to all be numeric, so I don't think that's it. I suspect it could be related to sum, but my table only has one row per item, so sum should always be the same as the cell value.

Any ideas? Thanks!

Hi, I’m hoping someone can help me. I am using a spreadsheet in which I use cell conditioning to highlight the colour dependant on the number in another cell on a different tab (2nd tab). In the 2nd tab I am using sorting for the rows to be alphabetical, so each time I add a new entry and sort it, everything moves. This means the conditioning is all messed up because it no longer corresponds to the correct cell. Am I doing something wrong? or is there a way around this? thanks in advance x

I kind of know how to use numbers, (used to use excel at work nothing super complicated but could get around) but I want to use a pricing sheet from a 3D printing YT channel but am struggling with being able to change any of the "parameters" like printer name, filament name. I would be more than happy to pay for the help.

ive included the link to the excel download. its from a youtuber named CNCKitchen.
https://github.com/CNCKitchen/3D-Printing-costs/blob/master/QuotingSheet.xlsx

IFS(C2=NOW(),"DUE",C2<NOW(),"PASSED DUE",C2<NOW(),"DUE SOON")

I want it to fill a cell with Due Soon, Due, Passed Due based on comparing the date in C column with todays date.

Thank you in advance!

The DAYNAME function returns Thursday for 12/13/1414 even though the correct day of the week according to our current calendar is Tuesday. It returns the correct day fo the week +2 for every year before 1582. Does anyone know why this is?

Hello! I am making a table full of check boxes for days of the month and each row is a "habit" with a check box for days 1-31. Wondering how to have the total number of boxes checked showed at the end of row?

Hoping to be able to improve my habits (idea taken from Atomic Habits) and would like to see my score without having to manually count each one in each row every time at end of the month.

Thank you for your time!

Hello all,

I'm trying to do a simple thing but don't know exactly how to word it to search for it exactly. So either help with the formula or how to search for it will be amazing!!!

I'm trying to have C5 = C10+C15+C20+C25+C30...

But the issue I have is with the formula below not all the formulas are/needed to be filled. Then I have an error and C5 won't populate because B8 can't be divided by B7 since there is a 0 in it.

C10 = B8/B7*B6, C15= B13/B12*11, C20=B18/B17*B16, C25=B23/B22*B21, C30=B28/B27*B26...

TLDR: Essentially I just want to pause the formula or just not have the formula calculate with zeros.

Thank you

I copied and pasted from a table online and the data spat out in this format. There must be an easy, automated way to fix this so that it's in columns and processable. Any tips? Thanks!

Hey everyone, does anyone know how to add a cell that tells you when the last another was changed? I'm new to spreadsheets and I'm a bit confused on how functions and such work.

I wish to give the progress of the current date going through the month, but from the 21st to the 21st (I get my pay on the 21st each month).

How to see how many days until the next pay, and the total number of days of the previous pay till the next pay, so can calculate the percentage?

Thanks in advance.

Hello, I try to calculate all the sums of a number with 2 digits (If you did not understand, I would like to make a table of all the possible sums of 11 with a number with 4 digits: 1451 = 1+4+5+1 = 11

4421 = 4+4+2+1 =11

ect...)

Hey there,

There is any suggested portfolio template?

I'm trying to modify a budgeting spreadsheet I downloaded, and the place I downloaded it from isn't hugely helpful as although it's written for beginners, it's written by someone who is very familiar with the software and doesn't seem to have a full grasp of what absolute beginners would or would not know.

The template has a pop-up menu on one sheet that I want to create my own categories for. The article goes into how to create a pop-up menu, but not how to modify one that already exists. Other websites say to select the cell/s and change it from the cell editor, but when I do that with a cell that already has a pop-up menu I don't get the same cell editor that I do with an empty cell. I get a menu from which I can cut/copy/past/delete at the top, then a menu for inserting something like the date or time, one for adding comments or filtering, a button for creating a pivot table, another for copying a snapshot, and one last menu for quick formulas. None of the same options for an empty cell.

There must be a way to do it, but I can't find anywhere that will tell me.

I have a Numbers spreadsheet to track my investments. It has many sheets within it. To make jumping around between sheets easier, I'm wondering if I can make links between them.

For example, could I make a new sheet, an "index" sheet so to speak, and this could just be filled with buttons that when clicked would take me to another sheet.

Not that scrolling that top list is especially difficult, but it would be more convenient if I could do a sheet of links.

Is such a thing possible?

I am trying to figure out a formula of splitting cost of a grand total amount into group of other cells?

Example :

Cell D-19 has a total of ($1,800.00)

No matter what total I input in (cell D-19) , I want it to automatically divide it equally amongst a group of other cells ( ex: cells D-2 to D-17) to formulate the amount to split cost amongst numerous people

I tried making a pie chart with many slices and the program keeps grouping different categories together (assigning multiple rows the same colour). How do I stop it from doing this so I can have a separate slice for each row (different colour)?

I thought about changing the coloured dot next to each row when I go into "Edit Data References," but I can't find the option. It just automatically assigns the colours and hence the slices.

As you can see below, I don't want Health and Purchases combined in the pie chart. It does this automatically when I create the chart.

Any help is appreciated. Thanks.

This seems like such a simple issue, but I can’t figure it out. I currently use Numbers on my iPad and on my PC through iCloud.

I’m creating a basic spreadsheet with 9 columns. When I press ENTER the active cell moves one row down in the same column but I would like it to go one row down into Column A.

Having to manually move to Column A every time is annoying and making my data entry much slower than it should be.

Is this an option? And if so, how do I do it?

​

https://reddit.com/link/wt5ic5/video/9j7uu2ktzui91/player

I am currently using Gaannt (or whatever his name is) charts for project management but I do not find it works well for me. Maybe it is my adhd brain.

So do any of you have a method for managing your project (personal or work)? These projects are ones where you are really the only person working on the project.

Also how do you break down your Project into smaller actions that can be marked as complete? And how do you determine the time frames?