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.
Hi. I am a project manager for a design build company and I am creating a template to use to forcast the labour required on a job that automatically decreases based on the percentage complete.
I am wanting to add a formula to one of my sheets that will automatically populate up to 4 column cells based on an option chosen from a dropdown menu.
The drop down will show which specific team members are required to complete a specific task ie: a Carpenter and an Apprentice out of a list of about 8 options. Once that is chosen I want the columns for Carpenter and Apprentice to be updated with the duration value multiplied by the percentage still to be completed with the column cells for the team members being left blank
These values are then totalled at the bottom of the sheet to give me a time value to complete the project which I then convert to a dollar value which is monitored against the budget
Thanks in advance