-
ADD LAST COMPLETE DATE
I have the following columns that are linked to another smartsheet: Citrix Status - Network Status - PC Status - Phone Status - Completion Date When all columns have the "Complete" status, the Completion Date will register the date of last column that changed to "complete" status. I really appreciate any help! Rob
-
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…
