Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Construction template

Diego García
Diego García ✭
edited 12/09/19 in Archived 2016 Posts

Has anyone created a template for construction comparing %completed, %programed and %paid vs the date? to be able to graph it something like this

 

construction graph 5 completed vs programed.png

Tags:
· Share on FacebookShare on Twitter

Comments

  • Dave D
    Dave D ✭

    There are construction templates in the template gallery. If you want to compare change, just add additional column with formulas comparing the values. 

    · Share on FacebookShare on Twitter
  • Diego García
    Diego García ✭
    edited 05/12/16

    The comparing part I've got I can adjust my gannt program and have a sheet give all of my payments from which I can have %payed and % completed.

     

    The tricky part for me is trying to create a sort of a cashflow that can be graphed across time that integrates %programed and the %actually executed. This so as to now if my contrator has gone acording to shecule and If I have payed him on time.

     

    It can be as this template shows, the problem is that I would have to adjust the month for every house that I begin, and input all my tasks for each month. I dont know if the ir a way to do it witouth as many date columns. MAYBE A TODAY FUCTION AND END DATE? I REALLY DONT KNOW IF IT IS EVEN POSSIBLE

    https://www.smartsheet.com/solutions/monthly-budget-tracker

    monthly-budget-tracker-755x262.jpg

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    There is a TODAY() function. 

     

    Craig

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories