I have a project where the planned tasks are spread over several weeks, see attached. How is the summary % complete total calculated? Can I relate to %complete against project days? Regards Steve
Hey folks, any idea how to pull this information onto another sheet horizontally? Basically, I am trying to consolidate some project information as seen in the "Source" screenshot. This particular she…
First, awesome community! I've been looking all over for a solution to my problem, but cannot find anything that would translate to my situation. Hopefully I make some sort of sense describing my issu…
I am trying to write a formula that looks on another sheets row for an employee # and for a task code and then return the proficiency level linked to that task code. For further info I will try to exp…
I have built an automated alert that determines which columns to include from a large Smartsheet which uses the max 200 columns based on a number of parameters held within certain rows on the sheet. T…
I need to send out Architectural Survey team out to the field to survey the existing conditions of a restaurant. Information gathered is Electrical Information (Panel Size, # of Breakers), Equipment (…
Hi all, I am looking to add filters for Smartsheet documents. I am relatively new with Smartsheet and have been tasked with creating some documents and reports. We are attempting to model one of our d…
Hello, fairly new to Smartsheet and I have a question. We have a sheet for PO requests and one of the columns is for "Status" , it has several options from a drop down menu. What I would like is for o…
I have a construction schedule with start and finish dates. I want the check boxes for the at risk column to automatically check off if the project is late starting or late finishing. Can anyone help …
Is there any body that can help me with - how to setup " How to count Checkmarks in a column " I have a lt of columns which a need to have a total count of - In the top of the sheet or in the bottom. …
