-
Restore deleted automated workflows
Hi Guys, i accidentally deleted an automated workflow (automation) created by an co-worker on a sheet. Is there any way to restore it? I already checked the activity log and see the creation and deletion of the workflow but no way to recover it. I am the owner of the sheet. Thank you in advance.
-
Getting the email address for a contact
Hi, I have a contact column and I need the email address from the contact. Is there a way to derive the email address from a Contact column into another column as an email address?
-
Embedding PPT online and point to specific slide
I'm trying to embed a PowerPoint online document into my Smartsheet dashboard but I keep getting an error from Microsoft 365 to "Please sign in to view this file." Even after signing in, my web browser just disappears and it doesn't even take me to the PPT document. However, I seem to be the only one experiencing this…
-
Will users be able to make updates in a destination sheet via a form if it's linked to source sheet
Hi al - I'm planning on having a main project sheet for my team but want the cells will also be linked to their individual project sheets (aka their source sheets). I've created weekly notifications for them to update their project info in the main sheet. My question is will they be able to properly submit any updates into…
-
Automated Workflow Email Based on Date
Hi All, I am trying to setup a workflow to sends a reminder 2 weeks out based on the 'Start' column with the conditions that the % Complete column is not 100% or the Status is not complete. The problem is I keep getting a list of all the tasks in the spreadsheet.
-
Non-repeating email notification when value in sheet is reached.
Hi all, We have an automation set up to send an email for when a certain value in a cell reaches 50%, 75% and 100% of a predetermined value. For example, the automation will fire when the cell value is 10 of the predetermined value of 20 (50%). Our issue is that the notification fires off again every time the cell value…
-
Cell Contents deleted during edits
Hello Has anyone seen an issue where the contents of a cell are just wiped clean as you navigate from one cell to another by using the arrow keys or hitting enter? This appears to be a random effect and not browser based and appears to have started only recently. Did not do this before. Thanks
-
Using forms for ordering product
Afternoon, I'm working on an order for for our customers. Is there a way to have totals add up on the form? They receive free shipping for order over $2500, but I thought it would be easier for it to auto calculate instead of the customer doing it manually.
-
Automation Row Transfer - Not showing on the destination sheet
Hello, I set up an automation where when a certain field is fulfilled, it moves the entire row to another sheet. The automation moved the row off my sheet, however, it isn't showing up on the sheet where it's supposed to transfer onto.
-
View if sheet is referenced in a report or dashboard?
I am cleaning up the numerous sheets I've created. However, how can I see if the sheet is referenced in a report, dashboard, other? I do not want to delete a sheet that is in use.