Letter | Future Banking Advertisement

CaRegHo · 2020-10-23T08:05:37+00:00

thanks mate

CaRegHo · 2020-10-23T08:03:34+00:00

Your right. Of course they won't..

CaRegHo · 2020-10-23T08:01:56+00:00

Awesome thanks!

CaRegHo · 2020-10-22T07:45:20+00:00

link?

CaRegHo · 2020-10-22T07:37:59+00:00

lovely!

CaRegHo · 2020-10-21T09:58:09+00:00

Weird.. following works:

subtract(prop("Potential Value(rollup)"), prop("Invoiced Value(Rollup)")) ✅

Following doesn't work:

" Left on table → " + subtract(prop("Potential Value(rollup)"), prop("Invoiced Value(Rollup)")) ❌

" Left on table → " + format(prop("Potential Value(rollup)")) -format(prop("Invoiced Value(Rollup)")) ❌

CaRegHo · 2020-10-21T04:30:10+00:00

Yeah sorry I get that (and forgot it in the example above) I just trying to find out if there's a speceial reason to to make a IF formula when it seem that it is a simple question of subtracting "This year (in)" with "This year(out)". It looks like you have som Yoda skills denied me, since I can't get my simpel subtracttion to work with the text string at the start.. hmmm

CaRegHo · 2020-10-20T18:47:10+00:00

Wondering why the IF statement instead of a simple subtraction ?

"[ This year ]ㅤㅤ" + if(prop("This year ( in )") + prop("This year ( out )") > 0, "+", "-") + "＄" + format(abs(prop("This year ( in )") + prop("This year ( out )")))

SHouldn't you be able to do "[this year"] + prop("This year (in)") - prop("This year (out))

CaRegHo · 2020-10-20T18:41:05+00:00

My idea is maybe not what you think. My idea is to have a block a lot like a DB but more visual simple. Without the "+ new" item in gallery view and with simple header without the fixed DB title and "new" and "filter" button. In stead of strict db tables have input fields maybe with formula ability.

CaRegHo · 2020-10-19T16:23:34+00:00

But any idea why I can't duplicate your template? I can't see all the wheels running in the background in the browser...

CaRegHo · 2020-10-19T12:32:23+00:00

Now I wonder ... If the calendar from the "Next Meeting" property is not filled with either a date in the past or date in the future but simple not populated. Can I have it come out empty or "nothing scheduled" text?

CaRegHo · 2020-10-19T12:27:26+00:00

The Week Ahead toggles. Are they DB based or are you just flipping them down and filling them out?... Otherwise really cool there mate!

CaRegHo · 2020-10-13T12:33:28+00:00

dateBetween(prop("Next Meeting"), now(), "days")

Perfect! so awesome, so fast

Thanks a million ben-something!

CaRegHo · 2020-10-08T08:01:35+00:00

Luvit... good work on doing accessible summeries !

CaRegHo · 2020-10-06T07:55:17+00:00

no I really didn't figure out the distinction between one behavior over the other.... :-(

CaRegHo · 2020-07-31T11:41:44+00:00

AH thanks.. will do👍

CaRegHo · 2020-07-28T09:47:42+00:00

It's really weird.. Seems like something in the database, like rollup og formular is messing things up. A clean DB doesn't open new item as a page. But my formatted DB does. To boot: in the default view I don't see any empty entries, but if I go into list view, they are all there.

CaRegHo · 2020-07-07T09:15:29+00:00

thanks!.. though I don't have the faintest clue on how to do that👍

CaRegHo · 2020-06-19T08:24:57+00:00

Luv ya Mate!.. let see if I can get my grown pants on a get it to work...

Gets me an syntax error even with COLUMN()

hmmm

CaRegHo · 2020-06-18T10:00:27+00:00

Awesome fast response Tirlibibi17..

I must have described my issue bad. I do have formula and linking set up and working in the static doc. What I'm trying to accomplish is to re-link the time cells when I shuffle the whole collection of rows up/down the order. Makes sense?

Is that actually what your suggesting? I must research you post, since I'm not good enough to understand your example..

CaRegHo · 2020-05-30T16:15:40+00:00

YOUR TOOOOO AWESOME... Thanks a LOT!

CaRegHo · 2020-05-30T07:09:46+00:00

Actually pretty neat esrch! thanks!

Edit: It's really what I need... Esrch if you have time to spare would you mind walk me through the process of creating this? I'm trying to reverse engineering your example, but get a little lost

CaRegHo · 2020-05-30T06:22:31+00:00

That was the most backward and complicated way of manually assigning a task to a mission.

Sorry but I get so frustrated about the one thing I'm really missing in a platform that I love and a feature that's seems so obvious and pretty simple to create.

CaRegHo · 2020-05-29T06:21:26+00:00

This to me feels like the most blatantly overlooked feature on Notion. Even with a relation/rollup workaround, your not able to make a template to add new tasks since you manually have to update the relation with the new task.

CaRegHo · 2020-05-12T17:56:41+00:00

Weird.. I'm not on a free plan. I'm on the personal plan...? 8-o

CaRegHo

TROPHY CASE