Best Of
Re: Copy select data over to a new sheet?
Hi,
I hope you're well and safe!
You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.
Another option would be to use so-called helper sheets. In short, copy the row to a helper sheet and then use my method described previously to get the values you need to another helper sheet and then copy/move the row from that sheet to the main destination sheet.
To connect them row by row, you'd use an Autonumber Column in the Source sheet and add a so-called helper column to manually add the row id on as many rows as you think you need in the Destination sheet.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!
Andrée Starå
Re: Javascript SDK with Typescript
Looking at the commits for the Javascript SDK, it does look like they're working on some Typescript adoption… fingers crossed!
https://github.com/smartsheet/smartsheet-javascript-sdk/commits/mainline/
dmillerw
Shortcut to Dashboard Header / Bookmarks
I would love to have add links at the top of a dashboard that would jump to a specific point or tag on a dashboard. (preferably with a way to jump back to the top)
Deb Peters
Re: Little Data, Big Problem (Live Data Connector)
Tableau says: An error occurred while communicating with Other Databases (ODBC). Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.
There was an error executing an SQL query: 'no such table:
ODBC connections do work with small reports but refresh slowly as the report results increase. I'm running into the same issue with excel, Power BI, Tableau. Right now I'm going to guess that this is a smartsheet issue (unable to pass report data after the number of report rows exceeds a certain number).
Mike L.
Re: Need help calculating the percentage of all project tasks and return a value in percentage
That's a good idea too. Thanks Brittney!
Maty
Re: Autopopulate Answers
You could do this by adding a checkbox to your sheet and duplicating your second set of questions.
Set up form logic so that if the box is checked, the second set of questions does not appear.
Then in your sheet, you need 2 sets of columns for the second set of questions (i.e. two delivery address columns). One set would be populated by the form (and can be hidden). The other would contain a column formula that would use an IF function to return the values from the first set of questions (billing address) if the box is checked, and return the data from the hidden columns if not.
I hope that makes sense.
KPH
Re: Complex Form Logic Conditions based on Multiple Fields (AND/OR)
YES, this would be a great to have! Often I need to compare 2 different fields at the same time—and just can't. Which sometimes leads to awkward user experiences in the questions asked on the form.
chelinasr
Proofing acknowledgement
Introduce an acknowledgement feature to the proofing tool that can be used to track who has confirmed that they are aware this specific document exists.
Ryan C
Stop this information pop-up from appearing over the Subject bar
This thing is rediculously frustrating when you ahve to edit notifification subjects en-masse. Not only does it get in the way in the first place, but it forcefully re-appears when you move your mouse back to the subject bar after having moved it away.
Or at least provide an option to close it!
Ryan Catling
Re: Override column formula for a cell
I hope you're well and safe!
Unfortunately, it's not possible now (It's all or nothing), but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå