Best Of
Re: Can you uses forms to populate fields in existing rows instead of creating an entirely new row?
Happy to help!
You'd use a so-called helper sheet and have the initial form submitted to the first sheet.
Then, using the URL-query feature and an auto-number column or another unique identifier, you'd create a link to the form in the second sheet and send it in an Alert.
Using cross-sheet formulas (VLOOKUP or INDEX/MATCH), you would collect the data from the second sheet and, using the ID, connect them to the correct rows.
Make sense?
✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏
Andrée Starå
Re: Formula not working - correctly
Hi
Your current COUNTIFS will only count rows where the value in Range 6 matches exactly that in the primary column.
If you use the HAS function, you can count the rows where the value of the primary column is one of the multi selected options.
Replace
[Primary Column}@cell
With
HAS(@cell, [Primary Column}@cell)
KPH
Re: Autopoluate date information to another cell
Thank you for your quick response! That worked!!
jcurry
Re: Solution Spotlight (HLS)- Dynamic View for Insurance Verification & Accreditation Processes
Hopefully this works! Let us know if there any any issues. @HLChristiansen
tcleaning
Re: July Question of the Month - Join the conversation and receive a badge
What is a personal goal you've set for yourself this year, and how is it going?
That's an easy one. I know my workplace is under budget cuts and I have not been to ENGAGE the last 2 years. My personal goal is to attend ENGAGE in November. I bought my plane tickets already, and I have a plan for how to pay for the rest of the cost by the end of August. I would say that I'm about 10% done and 90% to go, but that's ok because it's a baby step in the right direction.
virgh
Re: Smartsheet shirts
Become a Smartsheet Mobilizer. They give you the option of ordering swag and you can then host lunch and learns, create slide-decks for peers or upper management and just be the ultimate Smartsheet person in your company 🙃
manley85am
Re: Community Corner Newsletter [July 2025]
That's great feedback @Cayla Davis! I've just switched the link so it goes to the latest page. You can share feedback here, and we also have this topic where it's easy for us to keep track of feedback and ideas for the Community. 😊
If you give yoga a try, I hope you'll enjoy it! That pretty studio, with all the plants and the garden on the back, was definitely a plus for me. 🌿
Rebeca S.
Re: DataTable used for a Datashuttle Workflow
Hi @kowal,
Thank you for your message. The DataTable is working fine and there are no issues with the current setup as you described. My question is about uploading data from an Excel file using a Data Shuttle Workflow, where the target sheet is already linked to a DataTable.
Alexandra P
Re: Introduce yourself & get to know your peers!
Hello, I'm Shaq. I'm quite new to the community being that I just found out about it two weeks ago but have been growing fast. I've been using Smartsheet to keep track of our companies Escalations/ Police dispatches, New hires' onboarding progress and our departments metrics that I showcase with dashboards.
An interest that I have found since moving to North Carolina from Kansas are Spartan Races. I Plan to complete a Trifecta Weekend this year which is a 5k, 10k and 21k in a single weekend.. I don't mind getting dirty.
Shaq McWilliams