Updating data in existing rows
Answers
-
@Robyn Pier Ok. I'll take a look.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Haha. I noticed the times were missing too. I just happened to still be in the Community so I got a popup and was able to pop right back here. Then I got busy and had to step away again. Hahaha.
You're in good hands with Andree. He's got this Smartsheet thing figured out pretty well, so I will leave him to the solution.
-
Thank you Paul :)
-
@Robyn Pier Is there a date that you or someone else set for the team on the field? If yes, which one(s)? Or do the team set all the dates themselves?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
The team sets the dates themselves. Or i input them, it depends. I'm new to the project so I am trying to find the easiest way to simplify the process. Whoever speaks with the nurse will provide me with the info of the new dates.
-
@Robyn Pier Glad we got it working!
For everyone else.
We used a formula with the VLOOKUP function.
More info:
✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå I finally got the company license and when I moved your formula to my live sheets it won't work. I am not sure what i am doing wrong.
-
@Robyn Pier I'd be happy to take a look!
Can you share them with me again?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi - can you share what you did? I have a request to create a sheet where a team member wants to input data, and then send a form link out for additional information to be collected. We would all of this information to be populated on one line, and it sounds like you possible got this to work if I'm understanding this thread correctly! Any help or advice you could provide would be so helpful! Thank you!
Sheryl Sheldon
Cincinnati Children's Hospital Medical Center
-
@Sheryl Sheldon It sounds like an Update Request may be a good fit for your specific situation. Your Team Member starts the row with their data then sends out an Update Request that arrives to the end users in a form like layout. When they submit the Update Request, all of the information is populated on the same row.
-
That may work! Thank you for the suggestion!!
Sheryl
-
Happy to help! 👍️
-
The new Healthcare Community Group is now live! This group is a space for all things Healthcare and your question sounds like a great use of a discussion post in the group. I encourage you to ask questions, share use cases and collaborate with others in your industry. We also have some exciting healthcare-related updates being announced in the Healthcare Community Group very shortly.
Please let me know if you have any questions about the new group!
-Brianne
Brianne Laird, Sponsorships & Brand Activations Program Manager
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives