I have two sheets,
1- Stakeholder matrix with contact information and checkbox for primary contact
2- Project plan
I need to pull the email address's from Sheet 1 that have been "checked" as primary into sheet 2
Are you able to provide screenshots (sample data if necessary) for context?
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
Sheet 1 - Stakeholder Engagement Matrix- If the Box in the first column is checked, I want to move the email address to sheet 2.
Sheet 2- Email should go in column labeled Client Stakeholders
We can help with a formula to pull the data over, but without knowing any criteria other than the checkbox it is hard to say exactly. I'll provide a formula and explain it, and if you need something else please let us know.
So this formula uses an inter-sheet reference to check and see if the Sign Off Document field from Sheet 1 is checked ("=1") and if so uses a second reference to bring the email over.
I would guess though that you need some other reference (Project name or number) to correlate Sheet 2 to the entry on Sheet 1. If that is the case, you could easily create a column formula that does this. That formula (built assuming you want to use the Project Name) would look like this:
This would go in Client Stakeholders on Sheet 2 as a column formula and you would need to create the references from Sheet 1.
Hope this helps!
Training Delivery Manager / Charter Communications
How do we know which row to put each email address in?
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I have a list of action items that can be assigned to several departments by using a multiple drop down list with dept. names in the assigned column I am trying to create a summary sheet to count the number assigned I have tried both Contains & HAS But my answer is 0 - Just using the count if gets me 23 and there are 2…
I am hoping someone might be able to guide me. I am trying to count how many of certain courses people are interested in. All options populate into the same column. Is there a way to do something like: =COUNTIF(Which courses are you interested in?, Project Management)
Hello! I have not written formulas in quite some time, and need some help. I want to check the "Most Recent" box, if it is the most recent submission for that workstream.
©2024. All Rights Reserved Smartsheet Inc.