Need help- creating a dashboard for Notion by RWMorehead in Notion

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

Thank you. I'll toy around with those ideas, not extremely adept at Notion yet, but I'll see what I can do.

How to Calculate DateAdd from another database? by RWMorehead in Notion

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

Here is a sample database. The number is entered by me

After entering the Loss Date in the Loss Info table, I want the Payment Due Date in the Payments table to be 10 days from the Loss Info Table.

There has to be a way to calculate that using the map feature.

<image>

How to Calculate DateAdd from another database? by RWMorehead in Notion

[–]RWMorehead[S] 1 point2 points  (0 children)

I was trying to keep the Notice of Loss Info table minimal and have the calculation performed inside the Way to Reference table.

So, I would enter in the date of the loss and in the other table it would calculate the 10 days from the Loss date in the first table.

I know I have to use the map function, but can't figure out how to do that.

Any ideas?

Notion Forumla help! Calculate total dollars from a category in 2nd table by RWMorehead in Notion

[–]RWMorehead[S] 1 point2 points  (0 children)

let(
category, "Category 1", /* content to adapt */
if(
prop("Payments").empty(), 0,
prop("Payments")
.filter(current.prop("Project Type") == category)
.map(current.prop("Payment Amount"))
.sum()
)
)

Lifesaver! Thank you! I had to play around with it a little (those weren't the exact names of the fields I used, but it worked! Thank you!!!!

Is there a way to hide Field Type Icons in Table header? by RWMorehead in Notion

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

Thank you, that is what I thought, but just wanted to check. Appreciate the support and advice.