Benches Uncategorized

15

Formula in a comment?

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I’d like to put a formula in a comment, but for the life of me I can’t figure out how this can be done (well I can type the formula, but it doesn’t calculate).

What I am trying to accomplish is basically a pop-up that gives me a relatively simple calculation. The majority of the time I don’t need or want to see the value, so I don’t want the formula/calculation taking up space in my pretty little table. A comment/note in the appropriate cell that I can keep hidden most of the time and then see on those occasions I need to, would seem to fit the bill perfectly. However, short of one of you guru’s showing me how to accomplish this, I think I’m gonna have to throw in the towel on this idea…

Message was edited by: ahenry00

15 replies

Sign in or join Beachball Help to reply.

  1. 0

    WWJD

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I would love to see this enabled also but Numbers does not have this feature.

    Regards,

  2. 0

    Ric Donato

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi ahenry00,

    Welcome to Numbers discussions.

    Yes that would be a nice feature for sure.

    Be aware folks on these Discussion boards are, as yourself end users not Apple employees.

    In the mean time please read the below instructions.

    Send feedback directly to the Numbers team for enhancement requests: at the top of your screen to the right of the blue Apple please click Numbers > Provide Numbers Feedback. Explain in detail what you would like to see added to Numbers. This makes your request known to that team directly; don't expect to hear back from them. I've sent many as well.

    Let's hope the next version of iWork incorporates many of the requested enhancements.

    Thank you in advance for doing that.

    Again, welcome to Numbers Discussions, have fun here.

    Sincerely,

    RicD

  3. 0

    Jerrold Green1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Click on the target cell, highlight and Copy the equation in the Formula Bar, strike the "esc" key, click the Comment Tool, Paste the formula into the comment field. Click the "-" in the upper right corner of the comment to Hide the comment, click the triangle in the upper right corner of the cell to Expose the comment. Hovering over the commented cell will also bring up the comment.

    Am I missing something?

    Jerry

  4. 0

    WWJD

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    "We" want a live formula that actually changes based on the referenced cells like a normal equation. Even Excel does not have this feature.

    Regards,

  5. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    We may insert a column which would remain hidden when we use the sheet.

    We may also use an other table to store these formulas so that they will not appear in the main one. We may put this auxiliary table behind the main one so we don't see it at all.

    Yvan KOENIG (from FRANCE mardi 6 mai 2008 08:09:36)

  6. 0

    Jerrold Green1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    ahenry,

    Continuing Yvan's line of thinking, it's also possible to have the displayed result in a particular cell, or group of cells, change to be based on a completely different equation, determined by the content of a key cell (like a check box) in another part of the table.

    Before you throw in the towel, give this group a specific example of what you'd like to do. You might be surprised at how easy it is to accomplish with the built-in features of Numbers.

    Regards,

    Jerry

  7. 0

    ahenry00

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    {quote} We may insert a column which would remain hidden when we use the sheet.{quote} That would certainly work. My understanding of how that would work though (and I apologize for being such a neophyte) is that I would have to go through some extra steps to unhide the column. While accomplishing the objective, it’s not as elegant as a little pop-up. Not knocking the idea, just wish I knew how to make the table “Apple-y”.

    {quote} We may also use an other table to store these formulas so that they will not appear in the main one. We may put this auxiliary table behind the main one so we don't see it at all.{quote} I’m not in front of a Mac so I’m going from memory here, but can this be combined with some conditional formatting (like a checkbox)? For instance, could I put the table containing the formula hidden behind my main table, then on the main (in front) table add a small checkbox column that when checked will bring the table in back to the front and overlay the result? Is that what you were suggesting Jerrold?

    {quote} Before you throw in the towel, give this group a specific example of what you'd like to do. You might be surprised at how easy it is to accomplish with the built-in features of Numbers.{quote} Like I said, I’m not a mac computer now, but when I get home I’ll throw up some screen prints that better explain what I’m trying to do.

  8. 0

    Jerrold Green1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    It's not possible to change the stacking order based on content or calculation, as far as I know, but it is possible, using Conditional Formatting, to get one table's content to become visible through another table, or not, based on content.

    It's also not possible to Hide and Unhide columns or Rows under program control, but it's so simple to do manually that it's not much of an issue. If you click in a table to activate it, and then hover your cursor over the column or row ID, a triangle will appear that if clicked will drop a menu of options, including Hiding and Unhiding.

    We look forward to seeing your examples.

    Jerry

  9. 0

    ahenry00

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I guess the best way to explain this is with a picture, so here's the relevant portion of the table.

    !http://i291.photobucket.com/albums/ll311/ahenry00/numbers-1.gif!

    What I
    want is to (when desired) hover the mouse over A2 to see how many day's have elapsed from the specified date. Let me just say up front that some of this is an attempt to really make numbers "be all it can be". I can always add a visible column that shows elapsed days, or like y'all suggested I can hide/unhide the appropriate column. I played around with conditional formatting to see what I could do. It seems that you can only affect one table that way. Meaning, if I put the formula in a table that is hidden by the main one, I can't seem to make it show by way of a checkbox. I see how I can leave a blank column that will show the elapsed days when I check a box, but that isn't as eye appealing as I was shooting for. Am I missing something?

  10. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I apologize but the described feature is not available.

    Yvan KOENIG (from FRANCE mercredi 7 mai 2008 09:48:57)

  11. 0

    Jerrold Green1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    ahenry00,

    Here's an example of one way to implement your switch.

    User uploaded file

    I've duplicated the tables in the example to show the two different states. In each example, there are three tables -- the main table, the control table and a hidden table that resides behind the main table.

    The main table accepts your input. The input isn't displayed by the main table because the opacity of the text in the main table, as well as the fill, is set to zero percent. The PopUp table, behind the main table displays all the data, input and calculated. The formula in the PupUp table cells is: =IF(Control :: $A$2, IF(ISBLANK(Main :: A2),"",DATEDIF(Main :: A2,TODAY(),"D")& " days"), IF(ISBLANK(Main :: A2), "", Main :: A2))

    Also, I set the Cell Borders of the PopUp table to zero percent opacity so that they wouldn't show as double lines in the case of imperfect registration.

    There are probably endless ways to approach this goal, but I offer this one as an indication that Numbers can do the job.

    Best regards,

    Jerry

    Message was edited by: Jerrold Green1

    Message was edited by: Jerrold Green1

  12. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hello

    a - we may shorten the formula:

    =IF(ISBLANK(Main :: A),"",IF(Control :: $A$2,DATEDIF(Main :: A,TODAY(),"D")&" days",Main :: A))

    b - it seems that I'm not well awaken but I am unable to get the fill's opacity to 0%.

    Yvan KOENIG (from FRANCE mercredi 7 mai 2008 11:20:13)

  13. 0

    Jerrold Green1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Yvan,

    Thanks for your comments. (As you can see by the time of my post, I was having some sleep problems myself.) I built the formula one feature at a time and didn't take the time to go back and move the ISBLANK test to the outside after I realized I needed it in both expressions.

    I also had some trouble with the opacity setting. I failed on my first attempt to set the opacity to zero and I have no idea why, but having done it before I knew that it was possible and kept at it until I succeeded. There's an interesting behavior with a Header row. Setting the opacity to zero on a header cell will reveal a white background, as if the header has two layers, not just a different color. Selecting an entire table and setting the fill opacity to zero will leave gray header cells. The easiest way to play with this is to place a filled shape behind the table so that you'll know immediately when the opacity of the table is changed. The most efficient way to achieve a transparent table is to first select the entire table and set the fill to None, and then select the header row and set the fill to None again.

    Regards,

    Jerry

  14. 0

    Jerrold Green1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    ahenry00,

    I thought that an additional graphic might be helpful. Here I have pulled the rear table to the side so that you can see it. Note that it's a plain table (no headers), one column wide, and it registers with the cells where you have input your date.

    User uploaded file

    Hope this helps.

    Jerry

  15. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hello

    I tried with Numbers in English as well as with Numbers in French.

    I applied your protocol but the table remains desperately opaque.

    Yvan KOENIG (from FRANCE mercredi 7 mai 2008 17:48:41)