How to write below formula in smartsheet

Finops C'ship

Hi .

Can anyone help how to write below formula in Smartsheet

Bassam Khalil

Hi @Finops C'ship

Hope you are fine, you can use the following formula:

=(NETDAYS(B@row, TODAY()) + 1) / (NETDAYS(B@row, C@row) + 1)

Finops C'ship

Hi @Bassam Khalil

Its not giving me the correct output.

I am looking for say for start date is 05/24/2021 and end date is 05/24/2021 it should update % complete as 100 %

THanks

Bassam Khalil

Hi @Finops C'ship

Hope you are fine, you can use the following formula:

=((NETDAYS(B@row, TODAY()) + 1)) / ((NETDAYS(B@row, C@row) + 1))

Finops C'ship

Hi @Bassam Khalil

Can you help me how to write the formula on the smartsheet.

'=(100/(end-start))*(today()-start)

Bassam Khalil

Hi @Finops C'ship

Hope you are fine, please try the following formula:

=(100 / (end@row - start@row)) * (TODAY() - start@row)

Bassam Khalil

 @Finops C'ship

 I will be happy to help you any time.

Finops C'ship

Hi @Bassam Khalil

Need a help of yours. complex one :-

I have Project Plan sheet for following data

below screenshot 1

I want to create a report based on status and weekly progress % Complete as shown in Screen 2

to create a dashboard chart as shown in 3 to show it in dashboard..

Can you help me on it. Also, this weekly progress report should not stick on below dates..it should keep on changing next month picking up the Sunday Date for all four week in a month.