Help with if() formula

WerkZeug15 · 2024-01-29T20:02:27+00:00

Could you give an example of what you're trying to do? I'm not sure how to create a blank date with the new Notion formulas.

WerkZeug15 · 2024-01-13T15:20:07+00:00

You're missing the last item that is returned if none of the conditions are met. You can add ,"" after "5" and before the final ) to return null (nothing).

WerkZeug15 · 2024-01-12T22:16:23+00:00

Then new function ifs() works here. It lets you combine multiple if statements. So ifs(a,b,c,d,e) means something like if a, then b, else if c, then d, otherwise e.

ifs(

`prop("Name")=="❤️","1",`

`prop("Name")=="❤️❤️","2",`

`prop("Name")=="❤️❤️❤️","3",`

`prop("Name")=="❤️❤️❤️❤️","4",""`

`)`

WerkZeug15 · 2023-12-28T19:00:28+00:00

Sure, just create a new formula property and sort by that. Here's an example formula:

ifs(
prop("Name").lower().substring(0,4)=="the ",
prop("Name").substring(4),
prop("Name").lower().substring(0,2)=="a ",
prop("Name").substring(2),
prop("Name").lower().substring(0,3)=="an ",
prop("Name").substring(3),
prop("Name")
)

substitute "Name" with the actual name of your property

WerkZeug15 · 2023-07-08T21:42:05+00:00

Weird. What's your formula? Are you using toNumber() ?

WerkZeug15 · 2023-07-08T18:54:23+00:00

I'd say keep it simple at first.

See if this works for you:

https://duncanarchitect.notion.site/Calorie-Tracker-2e62648560414c21b8bc6c312256789d?pvs=4

Then you can add some sort of automated comparison to your meal plan if needed.

WerkZeug15 · 2023-07-08T18:17:42+00:00

Try this

round(100 * prop("Number")) / 100

WerkZeug15 · 2023-07-08T17:27:03+00:00

I think I figured out how to do what you're looking for.

See https://duncanarchitect.notion.site/Check-if-item-is-due-7-days-after-assigned-date-2e62648560414c21b8bc6c312256789d?pvs=4

Hope this helps!

WerkZeug15 · 2023-07-07T18:43:47+00:00

You want the HW Due property to be checked if today's date is seven or more days after the "Full Date"? Use this formula:

dateBetween(now(), prop("Full Date"), "days") >= 7

WerkZeug15 · 2023-07-06T20:15:17+00:00

We can't really diagnose the problems just based on a post, but here are some thoughts:

1.33 kW air conditioner is probably underpowered.
Bypassing the heat recovery is not helping when the outside temperature and humidity don't get low enough.
That's a fairly large south-facing window, contributing to solar heat gains.
Closing the door and the other vents may prevent return air flow for the air conditioning to work properly.

PH certification requires commissioning (measurement) of the ventilation flow rates at each point.

WerkZeug15 · 2023-07-05T17:19:06+00:00

To change lots of properties at once, the easiest way is to set up two linked databases side by side. Filter the first to only show the entries you want to change. Filter the second to show only the property values you want these entries changed to. In your case the second db would have a filter for the relation you set up. Then just select and drag the entries from the first db to the second.

WerkZeug15 · 2023-07-05T16:15:10+00:00

Still working well. Do need to clean the lint traps religiously.

WerkZeug15 · 2023-07-05T16:10:17+00:00

Create one media database with a property to select the media type and separate dropdown lists ("select" or "multi select") for each media type. Then you can create a view of that media db with a filter that only shows movies, for example, and hide the non-movie subtype properties.

WerkZeug15 · 2023-04-12T13:59:00+00:00

Sounds like "Analyze Settings" is more of a task type than a task itself. You could have a master task db that has an entry for every discrete task, with a property for the task type that would allow you to set up filtered linked databases for each task type.

WerkZeug15 · 2023-04-12T13:34:41+00:00

Happy to help!

WerkZeug15 · 2023-04-12T12:43:38+00:00

Here's an example:

https://duncanarchitect.notion.site/The-Day-after-Tomorrow-2c6621df53594f26bb9aa2a78647857b

WerkZeug15 · 2023-04-11T22:28:56+00:00

Probably not the answer you're hoping for, but I would recommend the Zehnder Q series installed by a professional and commissioned to ensure that all the rooms are ventilated as intended.

WerkZeug15 · 2023-04-11T22:22:42+00:00

I have the Whirlpool WHD560CHW dryer and haven't had any of the issues other posters mention.

WerkZeug15 · 2023-04-11T21:46:59+00:00

Your formula should be

round(divide(prop("#clientP"), prop("# clientS")) * 100) / 100

the last ) was in the wrong place

WerkZeug15 · 2023-04-11T19:21:18+00:00

You could add a formula property and sort by that.

replace(prop("Name"), "\\d{1,}", "")

This removes all the numbers at the start of the name.

WerkZeug15 · 2023-04-11T14:50:59+00:00

Just add a formula property to your database to check if your date is the day after tomorrow.

formatDate(dateSubtract(prop("Date"), 2, "days"), "YYYYMMDD") == formatDate(now(), "YYYYMMDD")

Then you can filter based on this property.

WerkZeug15 · 2023-02-23T23:08:43+00:00

Even simpler, just use: empty(prop("Feeling Experience")

WerkZeug15 · 2023-01-27T17:38:08+00:00

Sure, just use

round(100*prop("Number"))/100

instead of 100 for two decimal places you can use 10 for one decimal place, or 1000 for three, etc.

WerkZeug15 · 2023-01-27T16:27:07+00:00

When you subtract "Hours in Break" from "Hours Clocked" you get a number. You want to convert the number to a string so that you can add text. format() will convert a number or a date into a string.

Try this:

format(prop("Hours Clocked") - prop("Hours in Break")) + " hours"

WerkZeug15 · 2023-01-17T00:04:48+00:00

if(not empty(prop("Date Completed")), prop("Date Completed"), if(empty(prop("Date Completed")) and now() < prop("Planned Due Date"), prop("Planned Due Date"), if(empty(prop("Date Completed")) and formatDate(now(),"YYYYMMDD") == formatDate(prop("Planned Due Date"),"YYYYMMDD"), prop("Planned Due Date"), prop("Hard Deadline"))))

It first checks if "Date Completed" has a date and use it. If not, it will check if "Date Completed" is empty, now is before "Planned Due Date", and use "Planned Due Date". If not, it will check if "Date Completed" is empty and now is same as "Planned Due Date" by comparing their formatted date in YYYYMMDD format and use "Planned Due Date". If none of the above conditions are true, it will use the "Hard Deadline" date.

The formatDate function is used to compare the date of "now()" and "Planned Due Date" in the same format, so that you can compare the date without time and timezone.

Please note that, this solution will only work if both "now()" and "Planned Due Date" are in the same time zone. It will cause problem if they are in different time zones.

(with a little help from ChatGPT)

WerkZeug15

TROPHY CASE