-
Common Notification Errors
I have two sheets that use the exact same workflow: Trigger: When rows added/changed When checkbox - checked Send to contact in a cell Then record date In one sheet the workflow works as intended. In the other, the workflow appears to work (date is recorded) but no notification is received. I have already confirmed that…
-
Submitted Date formula keeps changing because of Created Date time zones
I’m trying to create a reliable Submitted Date column based on the Smartsheet Created Date system column. The goal is for Submitted Date to capture the correct calendar date when the form was submitted and then remain unchanged. The issue is that the Created Date timestamp appears to be displayed or evaluated differently…
-
Automatic Emails from Reports
I have team member specific, multi project sheet, prefiltered Reports built out and I want to have these reports automatically emailed to the team member and myself every Monday morning before I'm in the office. The reports run off of the "Last 7 days" filtered for tasks accomplished. So having them automated to run and…
-
Is there a way to upload an excel file to replace a current sheet?
I have a 6 column, 10,000+ row sheet that feeds into other sheets of data through vlookup formulas, that I update on a weekly basis with new information from an outside source. the columns stay the same but the row #'s vary. is there a way I can upload the new excel version of the data to automatically upload the existing…
-
Automations Errors
Every week, I export my employees' time from QuickBooks to Excel and import that data into a new Smartsheet. I have an automation that copies those imported rows into a template sheet that formats the time data. Within the template, I have separate automations for each employee. Each workflow uses the employee's User ID to…
-
Remove "automation@app.smartsheet.com" from sender email address
The OIT Security department at my university received a report that an email from automation@app.smartsheet.com may be phishing. We send a number of Update Requests through Smartsheet that require action from the receiving party. If the email is perceived as phishing by the recipient (or flagged as Spam by the email…
-
Smartsheet Enterprise WorkApps Expert Needed (Architecture & Setup Assistance)
I’m building an enterprise employee onboarding platform in Smartsheet Enterprise for my employer. I already have most of the business requirements, workflows, and sheet structure completed. What I need is someone with real experience using Smartsheet Enterprise and WorkApps to help me properly architect the solution. What…
-
Automation Between Sheets?
Hello! I have 2 sheets and I'm trying to design some notification automation between the two of them and I'm not sure what I want is within SS' capabilities. Sheet 1 has an application associated with it, Form A. An applicant fills out Form A and the data is all populated in Sheet 1, the relevant info for this question is…
-
Checkbox not triggering Automation
Hi, I have a very simple automation set up where if the box is checked, change the dropdown column for that row to COE Team. I tried it and it didn't work. I waited for about an hour to see if it was taking a long time but it still is not working. There is no formula involved with the automation so it would be a manual…
-
Adding Grid Fields into an Automation
Hello Folks, I have an automation that emails/notifies me when someone fills out a form (see Figure 1). The form has several fields, and I'd like to embed those in the subject line of the email or body of the email. I am able to get the information in the body of the email as that's how SS is set up, but I'd like to embed…