Is there a way to auto populate a cell whenever I enter data in a row?
Is there a way to auto populate a cell whenever I enter data in a row?
For example, let's say I am adding information to columns B and C (no specific order) for row #1, and whenever I provide this information, I would like column A to auto populate with the Study ID (the study ID will be the same for all rows).
Thanks
Best Answer
-
Add this formula to the "Study ID" column.
It checks if either Name or Description is not blank.
=if(or(not(isblank(Name@row)),not(isblank(Description@row))),"STUDY NUMBER","")
Just to change "study number" by the number you want.
I fyou want both column "Name" and "Description" to be filled before showing the Study number, use this formula:
=if(AND(not(isblank(Name@row)),not(isblank(Description@row))),"STUDY NUMBER","")
Answers
-
Hi @Vane
I hope you're well and safe!
Yes, you could do it with a Formula or through a combination of a Workflow and the Change Cell Action.
Would any of those options work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and 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.
-
Add this formula to the "Study ID" column.
It checks if either Name or Description is not blank.
=if(or(not(isblank(Name@row)),not(isblank(Description@row))),"STUDY NUMBER","")
Just to change "study number" by the number you want.
I fyou want both column "Name" and "Description" to be filled before showing the Study number, use this formula:
=if(AND(not(isblank(Name@row)),not(isblank(Description@row))),"STUDY NUMBER","")
-
@Christian G. Thank you! I used the second formula and it worked perfectly. And thank you @Andrée Starå for the suggestions. :)
-
Excellent!
Happy to help!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. 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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!