-
Employee Main List Formula Modification
I am currently using the Return to Workplace template set. I want to modify the formula being used on the Employee Main List Sheet to only collect trainings attended if the column next to it says a specific project phase (Dropdown). I am dividing the trainings by phases but I don't want the Trainings Attended to account…
-
Networking days taken from a start date and then one of two columns
I'm looking to find the average working days from the start date to the date of the job's first review. The first review could happen in two different ways represented in two different columns, a work in progress review, or an official review. Depending on the complexity of the job they may or may not need a WIP review. I…
-
Automate duration values based on a particular selection made in a form
I'd like to automate timings put into the duration column (shorter than days, e.g. 3 hours, etc.) based on selections made in a form submission to a sheet. Alternatively, setting up an automated workflow in the sheet that will automate timings in the duration column. again based on a particular selection being made.
-
IF Formula with Multiple Choice
Hello! I want to build an IF formula into columns when the multiple boxes has selected the right department. IF the Authorizer is marketing and finance, the emails would automatically populate in marketing and finance column. Not sure if this can be done. Would appreciate your help greatly!! Thank you very much.
-
JOIN DISTINCT COLLECT or JOIN INDEX COLLECT w/ Multi Dropdown List
Hi, I want to return the "Assigned to" contact for the "Assignee Role(s)" selected in a multi-select dropdown list. Here are the formulas I've tried so far: JOIN(DISTINCT(COLLECT({Project Settings - Team Members}, {Project Settings - Contact Role}, CONTAINS([Assignee Role]@row, @cell))), ", ")) JOIN(INDEX(COLLECT({Project…
-
Visualize Workloads Across Teams with the New Capacity View in Resource Management by Smartsheet
Hi Community, The new Capacity View experience lives on the Schedule in Resource Management by Smartsheet. It's one view for resource, project and portfolio managers to monitor capacity and bandwidth across all their teams so they can plan, manage and allocate resources more efficiently. You can access this new view by…
-
lookup with multi select dropdown contact list
Hi All We are very new to smart sheet tool and we are currently in process of setting up our projects and creating a list in it. the problem we are facing is for example we have a project that is running in several countries as we speak and we want to look up the responsible persons email addresses for all those countries…
-
Help with #REF
All was good until... Everything was working as designed while setting up PMO template set. Not sure what I did but getting #REF error and would appreciate help in correcting the error . Thank you in advance for your help!
-
Project Brief or Project Charter in Dashboard Format?
Hi there, Has anyone created a dashboard template for a Project Brief or Project Charter? I'm looking for an easy way to compile project information and share during our steering committee meetings. Many thanks, Jasmine
-
Rolling up RYG status by workstream
Hello, I'm looking to write a formula that averages my health status, but by the workstream column. For example, in the screenshot below, I'm looking at the "Equipment and Technology" workstream. I am using a separate metrics sheet to write the formula, as there will be one roll up status for each of my workstreams…
