☑️Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
☑️Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
☑️Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
☑️Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
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.
Answers
Hi @Finops C'ship
Hope you are fine, you can use the following formula:
=(NETDAYS([email protected], TODAY()) + 1) / (NETDAYS([email protected], [email protected]) + 1)
PMP Certified
[email protected]
www.mobilproject.it
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
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
Hi @Finops C'ship
Hope you are fine, you can use the following formula:
=((NETDAYS([email protected], TODAY()) + 1)) / ((NETDAYS([email protected], [email protected]) + 1))
PMP Certified
[email protected]
www.mobilproject.it
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Hi @Bassam Khalil
Can you help me how to write the formula on the smartsheet.
'=(100/(end-start))*(today()-start)
Hi @Finops C'ship
Hope you are fine, please try the following formula:
=(100 / ([email protected] - [email protected])) * (TODAY() - [email protected])
PMP Certified
[email protected]
www.mobilproject.it
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
@Finops C'ship
I will be happy to help you any time.
PMP Certified
[email protected]
www.mobilproject.it
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
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.