Project Management
Discussion List
-
Index Match or Index Collect with multiple criteriaIn Formulas and FunctionsI'd like to return a Contact to a cell if two criteria are met. I've tried using the index collect formula copied below but I continue to receive #INCORRECT ARGUMENT SET. =INDEX(COLLECT({Vendor Contact}, {Project Name}, [Project Name]@row,…Answered - Pending Review 2.1K views 22 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Update on: Edit a reports without access to the underlying Smartsheet.In Using SmartsheetIs there any update on this function or a new workaround? Please see here: https://community.smartsheet.com/discussion/5916/editing-reports-without-having-access-to-the-underlying-sheet or https://community.smartsheet.com/discussion/17606/…
-
Formulas -Automated at risk statusIn Formulas and FunctionsHi all, I'm quite new and I'm struggling with a formula I need to apply. I need to have an automated "at risk" status (red, yellow, green) in my projects masterlist. Red: % Done is equal to 0% and the Start Date has passed Yello…
-
Formulas for % Allocation in Resource ManagerIn Using SmartsheetIs it possible to use a formula to generate a percentage in a % Allocation column for use in the Project Resource Manager? Or does a percentage have to be manually entered into the % Allocation column? I've done quite a bit of research on …
-
Formula for 2 columns - checkbox and a date rangeIn Formulas and FunctionsHi there - newbie here. Looking for help with a formula. I am trying to drive a metric which shows the percentage of activities on 'THD Brands' in the past week. The 'THD Brand' column is a checkbox, so essentially I need to count anythin…
-
How to have a date dynamically changed based on a value in another column?In Formulas and FunctionsI'd like to be able to have the dates in a column update based on the Sprint number. So, I've created a new sheet with one column with the Sprint # and a column for the associated dates. I have a column in my main project spreadsheet title…Answered - Pending Review 11 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Webinar recording available: Keep Your Projects on Track with BaselinesIn General AnnouncementsMissed the webinar? Catch up on the recording here. Join us on June 3rd for an introduction to baselines, the newest project management capability from Smartsheet. In this webinar, you'll learn how to easily compare planned and actual pr…
-
Flagging a double booked roomIn Formulas and FunctionsHi Guys I have a tracker that my team use to manage their daily tasks. However, due to COVID there can only be a specified number of people in a room at a certain time. Often rooms have been double booked, resulting in work being delayed. …
-
Representing activities/tasks that may be associated with multiple domainsIn Using SmartsheetHi - I am creating a complex project plan where I have identified domains (highest level), workstreams, and then activities. There are certain activities that may be associated with multiple domains or workstreams. Any tips on how to repre…