Best Of
Re: Unhide specific columns on a sheet
Hello,
Having to unhide all columns at once can be overwhelming for new users. From a developer stand point, it's horrible. I usually have to unhide all columns to develop automations and procedures through multiple sheets and reports. Just to properly set up a lookup function can be difficult for new employees who haven't used our procedures much.
It's not a big problem if 1 person is running the show, but as soon as multiple brains get put together and want to start developing procedures within their own departments, data can be easily forgotten and duplicated.
Some sort of task manager to show a list of the columns with the ability to possibly check/uncheck the individual columns that you want to be shown would be great! It can be set up on the right side bar and operate the same as the rest, within that bar, having the window that slides out after making a selection.
Like I mentioned above, as soon as there's more than 1 person working within the same sheet, confusion can easily be caused by a mis-click and the feeling of "starting over" the task (hiding columns) comes on.

Re: Unhide specific columns on a sheet
It seems this is a perennial request. I've found comments on this issue back to 2015, at it is no better in 2023. Very clunky interface. In Excel, if I know Column H is hidden I can use GoTo to go to H1 and then Alt+Col+Unhide. There is no equivalent in Smartsheet. I'm currently working on a project where, to unhide a column just to the right of a known column, I have to drag about 8 other columns unhidden, finally revealing the column I want. Then I have to hide those 8 columns again.
Come on Smartsheet, y'all can do better.
Deleting Rows from Dynamic View
Can users (not owner or admin) have the ability to delete rows from a dynamic view?
Thanks!

Re: Ignore duplicate rows in a report
You could group the report by date and then create a sub group by visitor.

Re: Introducing the 2023 Core Product Certification Exam + Community Badges
Thanks! I did the certification and found it fairly straightforward, although I wish there was a way to turn the missed questions into a learning experience at the end by providing more information on the questions that were missed. I want to be able to fill in the gaps in my knowledge about some of the topics, but there is no record of the specifics missed, only the general themes.

Use workflows to streamline your approval process
Suppose you work in a marketing department, and your team creates various types of content, such as blog posts, social media posts, and email newsletters. You want to establish a streamlined approval process to ensure that all content goes through the necessary stages before publication. Here's how you can set up a content approval workflow in Smartsheet:
Define Workflow Stages (Statuses):
- Draft
- Review
- Revision Needed
- Final Approval
- Published
Create Columns:
- Content Title
- Assigned To (for assigning tasks to team members responsible for the review)
- Due Date
- Status (dropdown column with the defined workflow stages)
- Comments (for feedback and communication during the review process)
Create Workflow Rules:
- Rule 1: When the status is set to "Draft," assign the task to the relevant team member for the initial review and set the due date.
- Rule 2: When a team member sets the status to "Review" and adds comments, automatically change the status to "Revision Needed" if any revisions are required.
- Rule 3: When a team member sets the status to "Final Approval," assign the task to the appropriate approver for final review and set the due date.
- Rule 4: When the approver sets the status to "Published," notify the team that the content is approved and ready for publication.
Collaborate and Track Progress:
- Team members can access the Smartsheet, review assigned tasks, and update the status and comments as needed.
- Approvers can easily view pending tasks, provide feedback, and approve the content for publication.
By implementing this content approval workflow in Smartsheet, you can streamline the review process, ensure proper feedback and revisions, and maintain visibility on the progress of each piece of content. The automation saves time by assigning tasks, triggering notifications, and keeping everyone involved in the loop. Additionally, the history and comment features in Smartsheet enable transparent communication and provide an audit trail of the entire approval process.

How to use Smartsheet API in Knime to get data
Hi All,
I was trying to use the GET Request node in Knime to get data from some reports and sheets using Smartsheet API.
But looks like I can only use "https://api.smartsheet.com/2.0/sheets" or "https://api.smartsheet.com/2.0/reports" to get info for all sheets or reports. And when I include the reportid or sheetid, it gives me 40x error.
Can you please let me know what is the correct way to use Smartsheet API in Knime?
Thank you.

Re: #INCORRECT ARGUMENT SET
Hi @WinaHath you have the same problem as Shubha did. You have too many arguments in your Collect statement. That's what that error means. Are you trying to find the first match for the Department Code in another sheet, where Approval Sequence=1?
If so, then don't use ,0 anywhere. I'm going to assume you want the first match in the Collect, so try
=INDEX(COLLECT({Approved By}, {Department Code}, [Department Code]@row, {Approval Sequence}, 1),1)

Re: Is there a way to automate new row upon receipt of email? And autopopulate basic fields?
Hi @CamSME
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
Here's a possible workaround or workarounds
- Using a 3rd-party service like Zapier or similar
- Using the Smartsheet API
Would that 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!

Re: OR in COUNTIFS Formula
Column formulas cannot reference a specific row number. All cell references must be "@row" references.
Try putting the date in a Sheet Summary field and referencing that instead or putting the date on every row and using "@row" references.
Date on every row:
COUNTIFS({part 3 #}, [Part Number]@row, {status}, OR(@cell = "Repaired", @cell = "Beyond Repair"), {rma closed date}, <=Date@row)
Date as Sheet Summary Field:
COUNTIFS({part 3 #}, [Part Number]@row, {status}, OR(@cell = "Repaired", @cell = "Beyond Repair"), {rma closed date}, <=Date#)
