-
Bulk POST operation syntax
Hi. I have been able to stumble my way to successfully add new rows to my Smartsheet with the POST API request. However, I can't figure out the correct format to send more than one row at a time. I see reference to Bulk Operations in the documentation but I can't find any examples of exactly what that looks like. Would…
-
Return a value based on multiple criteria
Hi Formula gurus I am looking for formula which returns a value from a single column based on multiple criteria. So from one sheet I have a part number column a Order no column and I want to return the purchase order no from another sheet which has the fields part number and order no fields in it too for the match. Hoping…
-
New Employee Onboarding and Ever boarding workflow in Smart Sheet
I wanted to share that our higher education division (3 units) needed a global system for onboarding and ever boarding so I created a system containing a task list, 3 dashboards (one for the supervisor, one for the employee, and one for systems), a short new employee form, along with automation and alerts for 3 time frames…
-
Auto-populating Primary Field with next number in Form
Good evening, I'm currently creating a form for our client to request new Change Requests. Our change requests have a Primary Field called 'CR Number' and have the following format: 2024-CR182. I've already created my form, but I omitted the CR Number since I can't auto populate it with the next number, ie 2024-CR183. Is…
-
Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
-
Can automated emails be sent when a ticket is closed?
We have our ticketing set up in Smartsheets with a form we provide to the business to complete. Is it possible for those who have submitted the ticket to receive automated emails when the ticket is closed/resolved? Thank you!
-
Clear a sheet using Bridge
Hi all, I have developed a Clear Sheet solution using Bridge. Using Bridge allows you to incorporate a sheet clear into a Bridge workflow, rather than trying to align timing between workflows and other sheet clearing methods like automations and Data Shuttle. Once setup, you simply call this Clear Sheet workflow using the…
-
Why can't I use hourly, daily or weekly on this automation?
I'm trying to make a daily notification for the automation below. But it won't allow me. Can someone provide ideas of what I'm doing wrong?
-
RM to Smartsheet using Bridge: Smartsheet Add Row (bulk)
Hi, I am reading Time Entries from Smartsheet Resource Management (RM) and writing them to a Smartsheet. In RM, the project is divided up into phases, which results in Time Entries being associated with each of the phases. The number of phases can be different for each project. Since there are hundreds of Time Entries to…
-
Arrows in a text row with other text.
I have created a sheet to track roadway sign damages and repairs. I have text column where I add the message for each sign. I want to add an arrow in the text string. Currently it shows: "Greenbo Lake / State Resort Park / (left arrow) 15 Miles" The 'slash' / denotes a line break. I want the (left arrow) to be an actual…