Can anyone help how to write below formula in Smartsheet
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)
☑️ 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 %
=((NETDAYS([email protected], TODAY()) + 1)) / ((NETDAYS([email protected], [email protected]) + 1))
Can you help me how to write the formula on the smartsheet.
Hope you are fine, please try the following formula:
=(100 / ([email protected] - [email protected])) * (TODAY() - [email protected])
I will be happy to help you any time.
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.