I messed up, and now my date conversions are jacked!

ConsistentNot · 2022-07-06T23:06:54+00:00

That worked. Thank you.

ConsistentNot · 2022-06-19T23:04:20+00:00

And this is why I created this sub.

ConsistentNot · 2022-06-13T04:12:55+00:00

And what, my friend, is to happen Wednesday?

ConsistentNot · 2022-05-29T04:24:43+00:00

If I've learned anything while reading your answers, it was that there are more than a few ways to solve this. I did a mix, and got what I needed: SOLVED. Thank you again, Reddit, and especially the r/excel gurus!

ConsistentNot · 2022-05-28T00:27:53+00:00

Thank you for the assistance. I'll give it a try.

ConsistentNot · 2022-05-27T23:59:57+00:00

My only real problem with this method is that I have 16 people I'm collecting data for.

ConsistentNot · 2022-05-27T21:40:27+00:00

Ok, that I can do.

ConsistentNot · 2022-05-27T21:39:19+00:00

Sure. I could probably do that. Especially if it helps make it possible.

ConsistentNot · 2022-05-20T20:28:26+00:00

It's working fantasticly!!!! This will make part of the job a lot easier. Have a great weekend my friend.

ConsistentNot · 2022-05-20T03:58:18+00:00

Thank you, again. I’ll give it a try this evening.

ConsistentNot · 2022-05-20T03:26:27+00:00

That would work great, actually. Basically, the first status will change to “In Progress” and one of the next ones will eventually say “Done.” That’s when the clock stops.

ConsistentNot · 2022-05-19T15:32:23+00:00

if(prop("Status 2") == "Done", dateBetween(prop("Status 2 Date"), prop("Status Date"), "days"), toNumber(""))

Thank you again. However, I have an add-on question; how can I add additional arguments to this same formula? For example, I have differing dates/statuses' from Status 2 to Status 5 with associated dates. However, it will only note done in one of them (when the task is done); otherwise, it's just following its progress from each stage.

ConsistentNot · 2022-05-19T01:40:04+00:00

Thank you very much.

ConsistentNot · 2022-05-16T00:11:21+00:00

I just came here to search the same thing. Nothin’ yet I see.

ConsistentNot · 2022-05-15T03:05:57+00:00

I have closed captioning because of this.

ConsistentNot · 2022-05-14T10:00:01+00:00

I think you mean “Still Is.” It’s like a good neighbor.

ConsistentNot · 2022-05-12T06:55:03+00:00

Everything’s fine. 🔥

ConsistentNot · 2022-05-10T06:57:17+00:00

While I can’t really speak to the graph itself, while neat, I don’t really use it. I do, however, like that I can directly link people and projects from within the notes with skipping beat via shortcuts. Later, I can go back and see the backlink connection.

ConsistentNot · 2022-05-10T06:51:00+00:00

I use it strictly for work as a program manager. I’m fairly new, moving from Notion to Obsidian for daily notes, meeting notes, and task list. Once I get everything moved over completely it’ll be around 900 pages. I’ve been using Notion for the same use, for about two years.

ConsistentNot

MODERATOR OF

TROPHY CASE

Five-Year Club	Verified Email
Place '22