Adding a Throughput column

Hi All,

I have column A which contains a date, and column B which contains statuses, i.e. 1.Completed, 2. Descoped 3. Connected.

I'd like to create a column which puts '1' in all the records that have a 1.Completed status between Last Saturday and today's date -1 (from Saturday of each week to the actual date -1, in this case would be 10-Oct-20 to 13-Oct-20).

Any Ideas?

Many Thanks and btw this community is awesome.

Gaetano

Expression

Accepted answers

All comments

atcodedog05

Hi @Gaetano_B

Glad you are enjoying the Community. Its a great platform 🙂

Here is a workflow for the task.

Output:

Calculated fields:

Workflow:

Please check and let me know

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

flag.yxmd

atcodedog05

Hi @Gaetano_B

I do have a question is Last Saturday considered based last Saturday to today or last Saturday to date

Previous is considering last Saturday to date. Here is a workflow which considers last Saturday to today.

Please check and let me know 🙂

flag_v2.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703