Is there a way to choose a different column in a report as the primary column? I don't want the one Smartsheet chose.
There's no way to select another column and make it the primary column (from what I know). The only way to switch a primary column is a work-around:
Not perfect but it works...
Hi @Lashawnta Barker
I hope you're well and safe!
To add to Cody's excellent advice/answer.
What I usually do is concatenate the information that I want to include in the Primary column either by using + or/and using the JOIN function.
Here's an example of a rather advanced one. (I used this in a client solution for seeing more information in the calendar)
=JOIN(COLLECT([Appointment Date]@row:[Customer ID]@row; [Appointment Date]@row:[Customer ID]@row; NOT(ISBLANK(@cell))); " - ")
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Thanks guys. I understand your solution @Andrée Starå . That will be useful in another task.
For now, I'll go with the column switcharoo from @Cody Holmes
You're more than welcome!
Column switcharoo! 🤣
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Would it be beneficial to include an option that enables a forms user to complete a form and then initiate a new submission for the same form. Currently, users can navigate back using the browser's back button, but they are required to overwrite all the previous answers, which can be cumbersome.
I have data in Excel that I need to import on a weekly basis into Smartsheet (lets say columns A-F) I would like to have columns (lets say G-H) with formulas. How do I import data each week replacing the previous week's data (only columns A-F) without overwriting the formulas? Is it possible to do this via Datashuttle or…
We had a Latest Comment column but the Column Type wasn't accurate. Showing as a Text / Number type. I tried to resolve this and I get the error "There is already a Latest Comment column in the sheet". To try to resolve, I created another column and deleted the original. However this still hasn't fixed the issue. There are…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.