We have over 50 team members with their respective managers. When filling up the form when the manager is selected only his team needs to appear in the next field. Is this possible?
Yes, it’s possible.
You’ll have to add so-called helper columns for each manager's team and then add the team members to those contact list columns.
To make it work, you’d use the Logic feature and, for example, use the manager column, and when manager 1 is selected, it will show the team for manager 1 and so on.
Would that work?
I hope that helps!
Be safe and have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Thank you so much, This worked for me.
Have a great week ahead.
You're more than welcome!
Glad to hear that it's working!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
I am going to try this out.
Happy to help!
Let me know how it goes!
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
I need a formula that will count the day that a row is "Open" but stop counting the days once its "Closed" both instances need to display the count. Here is a formula I was trying to use. Thanks =IF([Date Closed]@row > 0, ([Date Closed]@row - [Date Opened]@row), TODAY() - [Date Opened]@row)
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.