How to write below formula in smartsheet
Hi .
Can anyone help how to write below formula in Smartsheet
Answers
-
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)
bassam.khalil2009@gmail.com
☑️ 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"
-
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(B@row, TODAY()) + 1)) / ((NETDAYS(B@row, C@row) + 1))
bassam.khalil2009@gmail.com
☑️ 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"
-
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 / (end@row - start@row)) * (TODAY() - start@row)
bassam.khalil2009@gmail.com
☑️ 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 will be happy to help you any time.
bassam.khalil2009@gmail.com
☑️ 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"
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!