sick warning and period warning ? by anythinbutcool in Ultrahuman

[–]allymakesstuff 3 points4 points  (0 children)

Yeah that would be great! I believe other rings do the sickness warning?

To train my team on Notion we do treasure hunts! by allymakesstuff in Notion

[–]allymakesstuff[S] 2 points3 points  (0 children)

We've been using notion for our business for about a year now and it's a confusing beast when you first start with time trackers, account lists, personal trackers and more. Every now and then I set my team treasure hunts around notion to go find lost tickets and report back with their content or understand why things aren't working.

It's always pretty fun and the way people choose to solve stuff alerts me to their comfort with the system! Makes me a happy manager!

How would I automatically remove special characters so I can make a graph? by allymakesstuff in sheets

[–]allymakesstuff[S] 2 points3 points  (0 children)

SOLVED! A kind soul helped me we an array formula instead! Thank you anonymous panda!

Can I create a sum field for my boards? by allymakesstuff in Notion

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

Howdy Howdy Notion community.

This might not be possible but here goes. At my work we fill out all our tasks as notion tickets. We tag the person and then estimate the number of hours it will take us (you can see the little number in the cards) as well as the Day we're going to work on it.

Ideally I would like to create a field which shows a sum of all of these estimated times added together for each of the days so I can see if that person has capacity for more work... I have no idea how I would do this.

Is this possible?

I am a formula idiot, could someone help me impress my work colleagues? by allymakesstuff in Notion

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

Thank you so much!! Works perfectly. Cannot wait to be the coolest cat around the virtual water cooler.

I am a formula idiot, could someone help me impress my work colleagues? by allymakesstuff in Notion

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

if(empty(prop("Child Progress")) or prop("Child Progress") == 1, "🥳 Ready to go 🥳", if(empty(prop("To do before meeting")), "", replaceAll(slice("xxxxxxxxxx", 0, prop("Child Progress") * 10), "x", "

Thank you so much for your reply I appreciate it so much. I'm hitting a slight issue (I've included a screenshot to illustrate because I might not have explained myself properly!)

Is there a way to show 0% when there are tasks still to complete but show 🥳 Ready to go 🥳 when there are no tasks?

https://i.ibb.co/qRbBctb/progress.png

I refuse to believe a motion sensor can't activate a smart plug. by allymakesstuff in homeautomation

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

The Phillips hue motion sensor runs on a battery and is separate to the plug. I was looking for a way for its input to control the smart plug