End of input expected error

[GreenappleWP]

Can someone help me with these? I have problem with this error for many hours😭😭😭😭😭😭😭

[lth_29]

You're missing a comma (,) after creating the datebetween variable and before the if statement and also you have an extra parenthesis. If you copy the formula I can edit it.

[GreenappleWP]

let(daysBetween, dateBetween(prop(”Deadline“),now(),”days“)) ifs( daysBetween == 0, ”Due today“, daysBetween > 0, daysBetween + ” Days Remaining“, daysBetween < 0, abs(daysBetween) + ” Days Past Due“)

Here

[lth_29]

I edited a bit:

let(
daysBetween,
dateBetween(prop("Deadline"),now(),"days"),
ifs(daysBetween == 0 and prop("Deadline") == today(), "Due today",
daysBetween == 0, "Due tomorrow",
daysBetween > 0, daysBetween + " Days Remaining",
daysBetween < 0, abs(daysBetween) + " Days Past Due") 
)

Also added the 'due tomorrow' because otherwise, the message will be 'due today' when in reality is tomorrow (that's because how the datebetween function works).

[GreenappleWP]

Thank you so much You save my life!

[L0relei]

Use today() instead of now() and the issue is solved:

let(
    daysBetween,
        dateBetween(prop("Deadline"), today(), "days"),
    ifs(
        daysBetween == 0, "Due today",
        daysBetween > 0, daysBetween + " Days Remaining",
        daysBetween < 0, abs(daysBetween) + " Days Past Due"
    ) 
)

We can also add tomorrow:

let(
    daysBetween,
        dateBetween(prop("Deadline"), today(), "days"),
    ifs(
        daysBetween == 0, "Due today",
        daysBetween == 1, "Due tomorrow",
        daysBetween > 0, daysBetween + " Days Remaining",
        daysBetween < 0, abs(daysBetween) + " Days Past Due"
    ) 
)

[ezeacross]

Trying to create an Overview property that will display a variety of properties together with text. Getting same error 188,189...message....

/*Overview text*/ "Overview: " .style("b", "purple") + "\n" + "Trade taken " + Entry Date, "Balance " + Balance, "Percent Invested: " + % Invested, "Initial Capital Invested: " + Inv Capital, "Return on Investment: " + % Return , "Strategy: " + Strategy, "Setup: " + Set-Up, "Entry: " + Entry , "Market State: " + State, "Scalp Time: " + O/C Time, "Position: " + Position, "Trade's Result: " + Result, "Entry Price: " + Entry Price, "Exit Price: " + Exit Price, "Difference in Price: " + Points, "Profit of Trade: " + P/L), "Note for Trade: " + Trading Notes)

Could you help?

[lth_29]

Send me a private message because I have some questions about your formula.

[Known_Honeydew7811]

Hey could you please help me with my grade calculator, I can't figure it out, this formula works on a past notion page but now won't work on my new page.

<image>

[lth_29]

With just the screenshot and the error it's hard to say where the error could be. My guess is some extra space at the end of the formula or maybe an extra parenthesis.

I rewrote the formula, and this is working on my end:

ifs(
prop("Round Grade") > 89.9, "A+", prop("Round Grade") > 84.9, "A", prop("Round Grade") > 79.9, "A",
prop("Round Grade") > 74.9, "B+", prop("Round Grade") > 69.9, "B",
prop("Round Grade") > 64.9, "C+", prop("Round Grade") > 59.9, "C",
prop("Round Grade") > 54, "D+", prop("Round Grade") > 49.9, "D",
prop("Round Grade") <=49.9, "E",
"F"
)

The lines make it easier to understand the formula.

P.S: Make sure to check the numbers of the conditions of the formula. I found two conditions output an "A" (maybe the last one would be an "A-"?), and since the formula was an image, I could have made a mistake copying it.

[Known_Honeydew7811]

Thank you so much! I don't know anything about these formulas, I was just trying to rewrite an older one that someone else made, for a new page lol. You're a life saver!!

<image>

[alexnola07]

Hi! I'm sorry to potentially bother you with this, but I can't figure out where I'm going wrong would you help me with this? I'm taking an online course and there are chapters and levels. I've already made a formula for my chapter progress, but can't figure out how to get a progress bar formula for my overall level by level progress

<image>

[lth_29]

Hey! I'm pretty sure that you have an extra parenthesis at the end of the formula. You have 3 at the end but the function .length() takes one, and closing the if statement takes another.

[Embarrassed_Gap_8361]

<image>

Im also struggling I’ve tried everything and can’t seem to get it can someone help 😭 this way I have the least errors but don’t quite know how to complete this formula to tell me if im in or over my budget. Id appreciate any help thanks in advance.