-
Predecessor formula Help
help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 points 3) All tasks that have a predecessor with a task number (which is not completed and overdue by date) This should all…
-
Project template sets - weighing options
Hello, all! What's the benefit in using the PMO template set over the Project Tracking & Rollup set or the Construction & Facilities/Multi Project set? In looking at each, and playing around with the PMO set, it seems like it might be more robust than what we need. We have multiple clients, some with multiple projects.…
-
Merged: Sheet Name URL in DV
This discussion has been merged.
-
New Enhancements in Timeline View – More Flexibility, Less Clutter!
Hi Community, We’re excited to share two updates in timeline view that make managing your projects even easier: Directly add and delete bars and milestones – No need to switch to grid view; you can now build and adjust your timeline directly in timeline view. Expand and collapse hierarchy – Visualize the big picture easily…
-
INDEX/MATCH works in one sheet, same formula gives #INVALID OPERATION in another
Hi all I have a Project Info section of my schedule sheet that I pull into columns so that the info can be used in automated emails about tasks. The sheet that's giving me problems is a copy of another sheet, where the formula works. =INDEX([Task Description]:[Task Description], MATCH("Portfolio", Task:Task, 0)) It works…
-
Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
-
New Templates?
Hi Smartsheets Crew; I wanted to know if you guys are going to create any NEW Templates in your Solution Area OR 🤔 If you plan on ENHANCING / ADDING to your EXISTING ones (to utilize any/all recent changes to the software) since the Template(s) was launched? 😁 It would be great to see some fresh new ideas that relate to…
-
percent column - are we all just guessing?
We're implementing a new template set for projects after some great sessions at ENGAGE. I'm writing some automations and getting things ready for end users to test but I keep coming back to the percent column. I'm stumped - how are others selecting or defining their percentages as a project progresses? How do we…
-
Is the Email Notification highlight color yellow definable?
In a standard email notification for sheet updates the changes are shown in yellow in the email body, is there a way to define that color to something other than yellow?
-
Merged: MORE SORTS ON REPORTS
This discussion has been merged.
