Hi all — Looking for some guidance on the below… I have a sheet named "Tracker" with a dropdown column of job levels (named "Target Audience") and another column that I am wanting to sum the job level…
Good afternoon everyone! Looking for some help with INDEX(Collect. I have a main sheet set up and also have created a helper sheet. Once the install date on the main sheet is changed, automation copie…
I need to reference another sheet to join and collect the skills of employees. The yellow is my desired outcome, and I'm using the following formula. Formula: =JOIN(COLLECT({Detailed Resource Data Mas…
Hello all, I am new to Smartsheet and this community, so I apologize in advance if my question has been asked and answered numerous times already. I just couldn't find my answer. Here it is anyway: I …
HI, I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a uni…
HI, I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a uni…
Hi, I'm trying to use Index/Match to list the mission statement(s) for each selected non-profit from a dropdown that allows multiple selection. The mission statement lives on a reference sheet and I'm…
I have a column in my grid that generates the Task number automatically for Level 2 and all of the children below it. IE if I choose the drop down "Task 1" for a row that is level 2 then that row and …
Hello, I have a helper column (Project Title) that is supposed to populate with the Project Name based on the below formula. The AI indicates that the formula is supposed to locate the cell in the col…
I would like to associate costs with tasks that we have in a program plan and then create a summarized version of this in another sheet. For organizational purposes, I'd like to be able to filter (and…
