-
Seeking consultants
We're an organisation responsible for government facilities management, asset management and projects . We currently use Smartsheets but require refined and custom built business solutions to assist in business operations. We're seeking expressions of interest for Smartsheets consultancy services and ongoing support.
-
Recommended format
Hi there, I'm looking to track daily activities of field staff. This involves broadly tracking daily tasks but perhaps more importantly location of staff in the field (who is where and when) and the work vehicle they are using (we have about 13 that are shared among staff). How would you recommend approaching this? Thank…
-
COUNTIF Formula for Contact Column
I have several tasks set up for team members using their email addresses in the Contact column. Some tasks have 1 member assigned and some have multiple. I have to run each person's workload and am trying to use a separate sheet that counts the number of times their email address is in the Contact column. However, the…
-
Color code Gantt bar
Hi there! I'm looking to code the color of Gantt bars based on the value of a different colum, called "Location". Is there a way to do this? Thank you, Esperanza
-
Project Management Office Template - Silly Question
Hi Community!! I'm working my way thru setting up a project portfolio using the Project Management Office template which is amazing! I have sort of a silly question......the Intake Form and Project Intake Sheet request something called a "Category". How should I think about categorizing the projects in the portfolio? How…
-
2 or more projects sheet dependency
HI, I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sheet. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> For example: Project A sheet Task # 25 on…
-
Project Phases of Development
Hello! I am trying to find a way to show the development stage of a project so it can be rolled into a report. Basically if all of the tasks in a section are complete, then the development stage would be the name of the next header task. For example (see image), if "Project Planning," "Drafting," and "Developing" are all…
-
Data storage EU
Hello! I'm afraid my question is not a new one, but I'm not giving up hope that Smartsheet is interested in expanding into Europe. Since I realized, that EU-GDPR seems to be accepted, the IT-data-security-departments at my Clients in Germany are still focused on where Smartsheet stores the data. Tha is top level of…
-
How to create a master schedule sheet in project prog schedule mode by linking other schedule sheets
Hello, first of all sorry for my English, I'm doing a translation from French. I work in the construction industry and we have big construction projects. Each major construction project includes several complex tasks. Each of these tasks is a project in itself and it has its own schedule. The goal is to bring together all…
-
Is there a way to create a list out of joined string in a cell?
I have Sheet A, were I have a column with Task Description that has parents. I created another column where I put the parents corresponding to the child. Example: Parent ID .........|........Task Description [blankcell]........|........Parent 1 [Parent 1].........|............Task 1 [Parent 1].........|............Task 2…
