-
Max and index match function
Hi all, i have a sheet where Trailers are logged in multiple time throughout the day and what they had in them such as a PO number or a load number in a separate sheet i want to type in the Trailer number and i want it to pull the recent entry date of the trailer and the Load number / po that came in that trailer. How can…
-
Is there a way to see if an Automation was completed?
Hello, I am having trouble with an automation not running. It will run sometimes and other times it will not. I basically have it where if text is entered into cell 1 it will change the status cell to closed, once closed it will send an email to a different person letting them know if the ticket is closed. Currently when…
-
Generate Document Automations Errors with Modified Column
Hi all, I'm encountering some issues with my generate document automation - The overview is: I have a sheet with a form input (Sheet A) and a main log (Sheet B) - the intent is to have users fill out the Sheet A form with each inspection, and that info is index collected into Sheet B to keep it clean and not have all the…
-
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…
-
How to build a row amortization formula
I have the following fields in smartsheet: Value: 10,000 Remaining Periods: 20 Amortization per Period: 500 I am able to create a row amortization in excel with a formula based on the "Column name", but unsure how to do this in smartsheet since I can't reference column name. Is there a way I can easily recreate this? (see…
-
How do I create an automation that ignores certain calendar days?
I created an automation in which I inserted 3 columns with dates in this way: Column 1: date A Column 2: date A +3 days Column 3: date A +5 days The problem: I would like the automation to ignore weekends and public holidays (of the Italian calendar). But I don't know how to do it, does anyone have a solution? 😊
-
Merged: Automation and Scheduled Emails - Only on the hour?
This discussion has been merged.
-
Workflow for After Hours Tickets
Hi all, I currently manage our support tickets smartsheet and live on east coast. I have a team member who lives on West Coast and I want to create a workflow to have any tickets submitted between the hours of 5pm EST and 8PM EST sent to him with a notification. Currently, I am capturing the date/time ticket is submitted…
-
Needing Two Timestamps in One Smartsheet
Hello, Can someone please assist with having two timestamps? I need to have our "Timestamp" in the first column when the customer submits a quote request, and another timestamp in "Arista Timestamp" (with date and time) of when "Quote Request Sent To WWT?" changes to "Yes". Right now my workaround is to have it record a…
-
Is it possible to edit an automation without removing all the subsequent actions?
Hello, I am trying to change one part of my automation for request an approval to requesting an update. Unfortunately, this part of the automation is towards the beginning and it seems the only way to edit the automation would be to erase and redo everything. Is there a way to make an edit with out clearing the rest of the…
