-
Copy New Row, Delete Old Row
I have a quick question. I have a process by which a row gets copied (from Sheet A) into another sheet (Sheet B). Since there will be duplicate rows in Sheet A, I'm wondering if there is a way in which when the row gets copied into Sheet B, a row can be deleted if another already exists? Essentially, I'm looking to avoid…
-
Automated Alerts - How to NOT to combine row updates
Hello! I need to send an email to our support team when a box is checked. Each row needs to be sent as an individual email so it becomes it's own ticketed item. Right now, If I check boxes for multiple rows the alert combines all the information into one email and sends when the sheet is saved. Is it possible to set up the…
-
Overtyping a formulas answer
I need to automatically calculate a number in one column based on another column, but also need the ability to overrule this result at times and manually enter an answer in the "calculated" column. When I do I don't want to change the column formula to a line formula as multiple lines are continually being added and things…
-
Return value based on a MAX date and other criteria
Me again Is it possible to create a summary report that shows the individual rows of data based on the latest date (Date of Completion) and other columns so as to only show 1 row per location (multiple locations can occur in a single building) - See example image below The items in green have the latest dates against their…
-
Why Created By (auto generate column) show automation SS email when we attach the file first?
When user firstly attached file before fill up other columns, "created by" column will show "automation@smarsheet.com" email. It seems that to get correct email, user need to fill up other column 1st before attach something. Can we change this? cause i need to use "created by" column for an email automation.
-
Workflow OR conditions
Hello, I am creating a workflow for notification (send out alert to my email address) while I have some questions about setting up the condition. It's a sharing sheet that people need to get into and update some fields. I have Column: Type - indicates the employee is a new hire or being terminated. Column: Date (to be)…
-
Trying to Count how many times a specific date populates
I am trying to count how many times each of of the dates in 'Clean Up Date' populate so I can set up a notification to deactivate the form that feeds into this sheet after 8 people sign up for each date. I've tried typing in CountIF formulas referencing similar questions asked in the past but nothing is working. I even…
-
Retroactive Workflow Solution
Hi If I create a workflow to copy rows to a new grid, will it work retroactively if the criteria was met before the automation was created? For example if my "approved" column has an "If YES move to new sheet" workflow added tomorrow, would anything that has YES in that column from today also move to that grid? Thanks Dan
-
Attachments in Alerts
Can anyone come up with a workaround for this situation: I have a submittal log for a construction project. I attach and log submittals in Smartsheet as they come in from the general contractor, and Smartsheet alerts the applicable designer that they need to review the submittal. Once they have done so and attached their…
-
Optimise Power automate for extract smartsheet
Hi, i would like to know how we could optimize the extract provess on power automat ? Today i'm using a power automate with HTTP connector and make a full extract of many smartsheet on O365 excel. It takes actually more than 5 hours to extract 35 smartsheet projects... I'm looking to improve that but i don't know how.…