How can I automate when a task is assigned from another user to automatically add to my sheet?
Hi @Kim Scanlon
Not sure I follow.
Do you mean when someone else assigns it to you?
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
I hope that helps!
Be safe and have a fantastic weekend!
Andrée Starå | 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
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.
Thanks for responding. So I am shared on a project sheet with multiple people assigned to different tasks. I currently get an email notification when the start date is approaching for a task but I'm hoping that I could also get that task added to my own personal task smartsheet. I took screen shots of the the project (project 101) sheet and my own personal sheet that I would like the task added to. Does that make sense? Thank you!
Happy to help!
You can either set up a Workflow that copies the row(s) over or use a cross-sheet formula structure to collect the information (see it).
Which option would work best?
I think just copying the row over would work- can we set that up for when the start date is approaching? I have the notification set up to notify the assigned person 3 days prior.
Yes, you can set a condition in the workflow.
I'm building a large master reporting sheet that cross references multiple other form response sheets based on a shared "incident number". I have six more columns of data to pull over from another sheet but have maxed out the cross sheet references (100 per sheet!) This master sheet then uses that data to create pdf's. I…
I have data in Excel that I need to import on a weekly basis into Smartsheet (lets say columns A-F) I would like to have columns (lets say G-H) with formulas. How do I import data each week replacing the previous week's data (only columns A-F) without overwriting the formulas? Is it possible to do this via Datashuttle or…
Would it be beneficial to include an option that enables a forms user to complete a form and then initiate a new submission for the same form. Currently, users can navigate back using the browser's back button, but they are required to overwrite all the previous answers, which can be cumbersome.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.