-
Move Row Automation to Top of New Sheet
If I automate moving a row from one sheet to another, it adds to the bottom...is there a way to have the Move Row automation add to the top of the destination sheet? This question was asked 3 years ago. Wondering if there are any updates. Thank you!
-
Can you Log a Cell In time?
Within my project sheet I have formulas set up to show me the present of Target duration vs actual completion date. The parentage in cell will change as we close out projects. Is there a way to track/Log this cell as it changes so that I can create a line graph to see our patterns over time?
-
Request an Approval now has the sheet link, why?
Does anyone know how to remove the sheet link option at the bottom of the approval workflow? When was this added, and why? This workflow should be treated the same as the Request an update, where it doesn't give the option to the approver to access the sheet. OR If approvers need more information than what would…
-
Automation - Workflow - Reminders when a date is reached
Hi, I created the below workflow to alert me 1 week before my due date column for a project I am working on smartsheet. I am not receiving any email alerts - I did check and I have all notifications allowed under my account so that is all good. Have I not set this up correctly maybe? Does it look okay or do I need to…
-
Checkbox find duplicate in a column, do not check either box if either has a value in 2nd column
I am using a checkbox to find duplicate entries in the column name Email. I can up with this that worked, =IF(COUNTIF(Email:Email, Email@row) > 1, 1). Next, I am looking for both duplicates to not have a value in the Using Generic Account field and then check both boxes. Do not check either box if one of the two…
-
Input/auto fill data from different rows
Hello, Please find the example photo I would like if there is a formula that can auto fill and input data in blank columns/same row once i type the phone number (in column phone) by calling or looking up for the data from other rows in same sheet (or from other data pase sheet) taht engaged with same phone number. For…
-
Why is my automation not triggering?
I have two columns I would like to run in an automation, one contains a check box and the other contains a drop-down menu of text values. I am trying to run an automation in which when I check a checkbox in one cell, it updates the "Status" cell in the same row to 'Complete'. The automation either doesn't trigger or takes…
-
Datamesh very slow to update
Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have I missed a trick?
-
Allowing Multiple Smartsheets to be published to One Google Calendar
I would love to be able to publish several of my smartsheets to one google calendar so everything is in one place. Please let me know when this feature maybe added! Thanks
-
Automated Email 2 days after a date if no attachment
Hi There, I have a fair bit of automation setup in my workspace for all the relevant rollout / install sheets to do multiple things including: Send reminders 1 and 3 days prior to ensure the store/retailer is aware and the space is clear Reminder on day of install at 5pm to ensure an attachment of the evidence of install…
