Best Of
Re: Work with Flow - A Space Story
@kowal I have the same plan. Currently spending every free moment I have learning as much as I can.
Isis T
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