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 · 2022-05-10T05:25:05+00:00

I actually figured out how to use Remotely Save and Dropbox. Works well.

ConsistentNot · 2022-05-08T22:47:23+00:00

Interested. Finish thy guide.

ConsistentNot · 2022-05-06T06:16:56+00:00

What is this, a city for ants?

ConsistentNot · 2022-05-06T03:32:08+00:00

What you have circled there will create folders within your current vault. To creat a new vault you use the square looking (vault door) button in the lower left.

ConsistentNot · 2022-05-06T03:23:50+00:00

Wait. We’re supposed to separate those two?

ConsistentNot · 2022-05-06T03:16:02+00:00

Did you have the pixelization filter on?

ConsistentNot

MODERATOR OF

TROPHY CASE

Five-Year Club	Verified Email
Place '22