-
Survey- how do you track projects over multiple years?
Hello Community, I am trying to track projects over multiple years, but each project varies in length. My concerns are hitting the max number of columns and not having to do a bunch of manual set up at the end of the year. Has anyone else had this issue? How did you solve it? Thanks, Ashley
-
Duration and Date Dependencies - Reference Cell in Same Sheet
Hi, Very novice user here. I am using Dependencies and am trying to find a way to make the Duration and Start/Complete Dates reference another cell within the same sheet. Screenshot attached. I'm trying to have the information in the Project Summary cells pulled into highlighted durations/dates so that it doesn't have to…
-
I need to calculate % Complete
Hi, I am trying to calculate % complete with an IF formula because if it is marked complete I want it to say 100% and the current formula is tell me it is 3,098% complete because start and end date are in the past. Old formula: =(TODAY() - [Start Date]@row) / ([End Date]@row - [Start Date]@row) What I am trying to write…
-
Pay Application Sheet
I'm a facilities project manager at an educational institution. We have begun using smartsheet for our project management tracking. I'm wondering if anyone has developed a pay application sheet they use in their applications. I think I could probably build one that will work but no need to reinvent the wheel if one already…
-
Project Collaborators Schedule Report
Hello everyone, I hope you're doing well. I'm new to SmartSheet and currently working on my initial projects and automations. I have a project group and would like to create a report in the project management office that allows me to identify all the collaborators involved in each project and in which months they will be…
-
Merged: Is it possible to simplify the process to set-up a reoccurring task?
This discussion has been merged.
-
Smartsheet Checkbox
Hi All! Thank you for your help in answering my question : ) I am wondering if there is a way to have a column filled with dates on one Smartsheet. And if the date is filled on this Smartsheet, have it presented as a checked box on a new Smartsheet. Essentiallly rather than our executive team looking at a bunch of dates…
-
Form Confirmation Options
I have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?
-
V-LookUp to see if the same number ID is found in two separate sheets
Is there a formula that would check if the number ID in one sheet is also found in a separate sheet?
-
Dynamic view for person & team
Hi I have several DV's set up for individuals to review a task list. These individuals are grouped into several teams. I have had a request to create a view that shows the team members tasks, as well as the tasks of other team members in the same team. Suggestions on the best way to achieve this?