-
Time Based Automation
I tried to create an auto clear function for a specific column using automation. It's should clear the column of its content at the start of every workday, however it does not appear to be working. Does Smartsheet need to be open for automations to work? Any information is much appreciated. Thank you!
-
third party application recommendation for robust sharing automation between sheets
Hi there, I'm looking to see if there an application that can handle a little more robust automation of sharing between sheets. I'm looking to create one form that can populate and update several different sheets. do I need a third party app for this? Thanks! Deanna
-
Nesting ISBLANK within IF(AND) Statements
Hello, I have successfully established a formula link between two date columns (Start & Finish) and my 3 status trackers (Completed, In Progress, Not Started). The formula I have used successfully is: =IF(AND(Start@row > TODAY(), Finish@row > TODAY()), "Not Started", IF(AND(Start@row < TODAY(), Finish@row > TODAY()), "In…
-
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…