I have a column of data that is dollar values, and I want a sum of that column. How do I write a formula to give that sum? And where do I place the formula?

Sorry for trivial question, but I am not sure why this source filter is not working:

#Done_B = null

I want to hide all items that  have the Tag #Done_B set. However, all items are hidden with it on.

When I copy/paste from Ecco Pro into InfoQube, the text often gets indented to the center of the page. 

Is there a way to prevent this without going thru a full-blown import routine?

Wayne

Win 10 - 121Pre3

When I sync Google Tasks to IQ, they are automatically synced to the DueDate field, and hence they appear in the color set for that field.

Is there any way I can change the color of these tasks in IQ (or, perhaps, sync them with some other date field), so they will look different on my IQ from other items which have a DueDate field (mainly my IQ reminders)?

Thanks!

I am repeatedly getting this error message:

Field FileFullName is slow to computer (took 4280 mSec) which affects UI responsiveness.  Consider hiding it in the Properties pane.  (Manage fields>Options>Check both checkboxes for "Hide in xxx').

Both boxes are already checked.  What can I do to make this stop popping up?

Wayne

I expected this has been asked before but I could not locate an answer.

Q. Is it possible (even on a limited basis) to edit the popup context menus. What I want to do is (possible) first hide some options and then rearrange the remaining to streamline my system.

Being able to have just my most used selections and in the order I use them on the menus would be absolutely outstanding. 

Any thoughts?

I pasted the following link as html in the URL field

CNN  ( it has the HTML code: <A href="https://us.cnn.com/">CNN</A> )
Clicking the link in the URL field works fine.

I used my Function, posted elsewhere, to modify my Item so that it looks like this:
My Item (Link)

and as HTML:
My Item <a href=[url]>(Link)</a>

I want to change the item (item text) by adding a link if a URL is added to the URL field.

For example:
myItem => myItem (Link) where "Link" is a hyperlink.

This test rule, in the URL field, works:
AME: [item]="test <a href="[url]">(Link)</a>"

It changes the item:
myItem=> test (Link)

However, I want the item to remain, so I tried these:
AME: [item]="[item] <a href="[url]">(Link)</a>"
AME: [item]=[item] "<a href="[url]">(Link)</a>"

None of these works; the item is not changed.

Hi Pierre,

Is there a way to select an item, and then open it in a new or scratch grid, so I can see it with all its parents and children, but without the grid source, filter and sort criteria of the grid where I found it?  In effect, a special kind of Hoist, because Hoist now keeps all the info from the source grid.  I tried using the omnibox search with its itemID but that didn't work.

Thanks!

How do I set a default frame color for calendar events which is different from the default fill color? (as e.g. in the event illustrated in the Calendar help topic labeled Meeting With Customer Planning, where the frame color is green, while the fill color is pink? - see also the different fill and frame colors in that same help topic for the events entitled: under Installation at the Customer's Facilities / first iteration coding).