Weeks out column

[Ayder_Humphreys]

Hi there, I work in events and I am trying to work out a way i can create a “Weeks out from event” column i.e. event date is 30 March - how many weeks out if my task Due date from this event date? Any tips would be much appreciated - I have not been able to find a solution

[Ka_Nishiyama]

Hi, @Ayder_Humphreys .
Just to confirm, is it the following image?

• Task name, due date, number of weeks
• Task A, July 7, 28
• Task B, August 7, 32

Task B is 4 weeks after Task A (32-28=4)

Expressed in Excel,
=WEEKNUM(August 7th)-WEEKNUM(July 7th)
=4

[Ayder_Humphreys]

thats right but i would wantNumber of weeks to be calculated based on the due date. so its not between two tasks. Its one task, but two columns

[Ayder_Humphreys]

[Ayder_Humphreys]

[lpb]

Welcome, @Ayder_Humphreys,

(Sorry, @Ka_Nishiyama, I had demo’ed this, then saw your reply, so just posting anyway in case of value.)

If the above is what you’re looking for, then I think unfortunately you need a column like Event Due Date (a Date custom field) that repeats the event due date, though you could set that automatically with a rule. The Weeks Remaining is a formula custom field like this:

Thanks,

Larry

[Ayder_Humphreys]

You have just solved my problem - THANK YOU!

[Ayder_Humphreys]

Sorry - Do you happen to know how i can run a rule to populate the entire column for event date? I have tried but it only runs it for one task

[lpb]

Yes, you could do this:

[Ka_Nishiyama]

Hi, @lpb .

This is what I was able to do with AI. (I feel like this is a waste of AI.)

---

P.S. Instead of using AI in rules, I was able to pull data from scripts, which doesn’t consume AI credits.