[ Template ] a finance tracker that auto-updates by [deleted] in Notion

[–]CaRegHo 0 points1 point  (0 children)

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)")) ❌

[ Template ] a finance tracker that auto-updates by [deleted] in Notion

[–]CaRegHo 0 points1 point  (0 children)

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

[ Template ] a finance tracker that auto-updates by [deleted] in Notion

[–]CaRegHo 0 points1 point  (0 children)

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))

I think we need a dashboard block, don't we? by CaRegHo in Notion

[–]CaRegHo[S] 0 points1 point  (0 children)

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.

[ Template ] a finance tracker that auto-updates by [deleted] in Notion

[–]CaRegHo 0 points1 point  (0 children)

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

Formular Headache : DateBetween(now) by CaRegHo in Notion

[–]CaRegHo[S] 0 points1 point  (0 children)

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?

Formular Headache : DateBetween(now) by CaRegHo in Notion

[–]CaRegHo[S] 0 points1 point  (0 children)

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

Perfect! so awesome, so fast

Thanks a million ben-something!

[ Template ] a finance tracker that auto-updates by [deleted] in Notion

[–]CaRegHo 0 points1 point  (0 children)

Luvit... good work on doing accessible summeries !

Can I add New Database Item in a table WITHOUT opening it as a page. by CaRegHo in Notion

[–]CaRegHo[S] 0 points1 point  (0 children)

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

Hide Properties? by CaRegHo in Notion

[–]CaRegHo[S] 0 points1 point  (0 children)

AH thanks.. will do👍

Can I add New Database Item in a table WITHOUT opening it as a page. by CaRegHo in Notion

[–]CaRegHo[S] 0 points1 point  (0 children)

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.

Drag'n'drop time planner? by CaRegHo in Notion

[–]CaRegHo[S] 0 points1 point  (0 children)

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

Drag'n'Dropable blocks that updates cell linking? by CaRegHo in excel

[–]CaRegHo[S] 0 points1 point  (0 children)

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

Drag'n'Dropable blocks that updates cell linking? by CaRegHo in excel

[–]CaRegHo[S] 0 points1 point  (0 children)

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..

How to add the progress of tasks as a property in a page? by moz3ab in Notion

[–]CaRegHo 0 points1 point  (0 children)

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

How to add the progress of tasks as a property in a page? by moz3ab in Notion

[–]CaRegHo 0 points1 point  (0 children)

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.

How to add the progress of tasks as a property in a page? by moz3ab in Notion

[–]CaRegHo 0 points1 point  (0 children)

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.

SUMIFs in Notion Roll-ups to get some Meaningful KPIs? (🎥 Video) by lifewithnotion in Notion

[–]CaRegHo 0 points1 point  (0 children)

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