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


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

  • 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



  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    There is a TODAY() function. 



This discussion has been closed.