How to write below formula in smartsheet

Hi .

Can anyone help how to write below formula in Smartsheet


Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 05/24/21

    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)

    PMP Certified

    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"

  • 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
    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))

    PMP Certified

    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"

  • Hi @Bassam Khalil

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


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

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Finops C'ship

    Hope you are fine, please try the following formula:

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

    PMP Certified

    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"

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

     @Finops C'ship

     I will be happy to help you any time.

    PMP Certified

    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"

  • Finops C'ship
    Finops C'ship ✭✭
    edited 05/27/21

    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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!