-
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?
-
Can I create one workflow to notify multiple conditional paths or does each condition need it's own?
Hello, I am trying to create a workflow where specific people at a given project are notified when a request is fulfilled. I have set it up as it appears in the included picture but I am only receiving alerts when the first project is selected. Do I have to create a separate workflow for each of the projects or is there a…
-
Ability to use "&" in "My Smartsheet Contacts"
We currently can't use an ampersand "&" as the contact name in "My Smartsheet Contacts". At my company, we typically use ampersands to identify groups in distribution email lists. Some examples are Marketing and Trading or Transmission and Distribution. which are shortened to M&T or T&D. My current workaround is to use a…
-
Hourly view on Gantt View
Hi there, We have a project with vehicles moving across multiple locations and would like to keep tract of their activity by the hour. We don't so much need to track their GPS location as much as, Car # 1 is in Town A, and then needs to go to Town B for 2 hours, then return to Town A. Gantt view would be very effective for…
-
Best Practices/Work Arounds for the lack of "elapsed" and "months" options
I want to open the discussion in this industry forum because I'm certain this would be a group of folks that regularly encounter this short coming. The inability to put "edays" in the predecessors column leads me to a ton of extra rows that serve no purpose other than being a way to get "# edays" in the duration column so…
-
% Complete Without Dates
Hey There, I work for a construction company, and one of our subdivisions has multiple townhome blocks. We are currently building 3 blocks, but don't know when we will start the other ones (all dependent on sales) I'm wondering if there is a way to get the % Complete for the whole project, not just the blocks currently in…
-
Today's Date in a Dashboard
Hi, I have recently gotten into using Dashboards within Smartsheet, amazing. Is there a way to display today's date in a widget? Thank, Scott
-
Critical CHAIN Project Management (CCPM) in Smartsheet
Can we do Critical CHAIN Project Management (CCPM) in SmartSheet? If we can, do we need add-ins or can anyone share a template?
-
Get dates and conditional sum of budget spreads
Hi Community. I have a spread of budgets but I want to retrieve the start and finish dates of the spread AND I want to get the planned sum of the spread up to a given date. Here is a print screen of the simplified table: The Start Date and Finish Date columns is supposed to have the formulas that read the start date and…