-
Log of Alerts
How do I find a log of the alerts that have been sent? I am trying to determine if an automation that I set up is working.
-
Simply Retrieving Last Row Referenced in Another Sheet
Simply, I need to reference another sheet and get all column values on the LAST row!!! I thought this should be simple to do by indexing another sheet, then capturing the last row and include all column values in this last row??? See Example: =INDEX({EXTERNAL SMARTSHEET Range 20}, LAST ROW, ALL COLUMNS) What am I doing…
-
Report Builder Automations
Hello Smartsheet Community, I'm building a report and I'm wondering if I click into an entire folder collection for my source sheet, will the report auto-include new grids that get added to those folders or will I have to manually add them as they get created?
-
Email automations in report not working
Hi. I need help with setting up a report to send monthly to specific email addresses every month. I saw others recommendations on automating the "Send as Attachment" in the report, which I tried and it is not sending the reports. Here's the steps I tried: I created a report "Gas Receipts Monthly Report" which will send a…
-
Grouped Update Requests
I am looking for a way to send multiple update requests in a single email. Here is the scenario. Once a product is inspected, I want to check a Smartsheet checkbox saying that it passed inspection. Then I want Smartsheet to automatically send out an update request to our shipping department telling them to go ahead and…
-
Automation in one sheet to change cell in another sheet?
I have two sheets in our workspace, one is the master list of projects we are working on, the other is used to record the amount of time each person works on a project for a given date. Projects sheet Timesheet sheet Project ID Project ID Project Name Staff Name Status Date Priority Hours Worked etc. etc. A project gets a…
-
New here, general questions
Hi, Do you have to write all the functions yourself or are there tools to help with the process. I need to do a xlookup index and matching update to another sheet. I'm use to work with ablebits tools. While I'm here, it is possible to upload to a file to overwrite (update) data on a current sheet? Can I sync two sheets so…
-
Employee Fit Testing Tracking
I am very new to creating my own smart sheets, I am looking to create a tracking of Employee Respirator Fit Testing. This sheet would need a away to annually updated by testing completion date as well as the type of mask they tested on, noting that some employees with have to complete fit testing on multiple masks each of…
-
Ranking Formula
Hello all, I have a sheet with columns that look like this: Spot in Queue Case Number Case Prep Completed Case Completed 1 100 x 2 101 x 3 102 Essentially, what I would like to do is change the spot in the queue when the case is completed. For example, when I check off 'Case Completed' for case number 100, the spot in the…
-
Automatic workflow not working
I am trying to set up a recurring date to be entered into the sheet using automatic workflow (photos enclosed) I want to be able to type in "blah blah blah" into the event name column and have it repeat every month on the the third sunday. What am I doing wrong?
