-
TODAY() Automated workflow birthday not calculating correctly
We've automated a work flow for birthday notifications - so we can celebrate folks. The workflow/notification shows an incorrect calculation - age = 20, when it should be 21. Here's the notification: And here's the data we're pulling from, showing the correct age calculation: I'm assuming this may have something to do with…
-
Mismatching cells notification
I'm trying to create a notification if two cells do not match each others values. We currently would need this is a production environment where a PO quantity is created and as the item is produced, if the department doesn't log the same quantity as the PO, the notification is sent to the supervisor. For example. IF PO…
-
Send automated alert from another user or group
Is it possible to change an automated alert email to send from another user or group to that of the sheet/workspace owner? I am the workspace owner and email messages are delivered to customers from me: Can this be changed to a different user or group email account without moving the sheet to another workspace that is the…
-
Automation with time & rows added
Hello, I am trying to figure out a way to send an alert when a new row is added AND have the automation run at a particular time of the day. If I understand the way the automation is configured, you can choose one or the other. Is there a way to say: If a row new row has been added as of 9am send an alert. Check again at…
-
Automating Date fill in other than Today?
I am trying to figure out if it is possible to use the automation function to essentially say, "when column A is filled in, mark in column B Today + 1." I'm not sure this is possible, but I wonder if anyone has been able to accomplish anything similar with the automation function. I specifically need this to be an…
-
Approval Workflow with Attachment in Response
I'd like to design an approval workflow wherein I need to automatically attach the same PDF file in all of my Approved Response email. Would that be possible? or my only option is to include a download link from Onedrive or Googledrive in the response so the recipients can get the PDF file?
-
Average/Roll Up Harvey Ball % Complete Symbol in Parent Row
Hello, I have a feeling this is going to be so simple, but I cannot seem to figure out how to average the values of the Harvey Ball % Complete symbol in a parent row. Per my screenshot, I want the Harvey Ball with the red arrow to average the values of the Harvey Balls beneath it. There is a parent/child relationship…
-
Unique countif on a multi-select use case
I have a sheet where we are trying to do a count of project for each person. Here is the information: The sheet lists all the services/applications that a team supports. There are potentially multiple team members assigned to support a service/application. We also have projects that may or may not span across the…
-
Copying data from Smartsheet to Excel with Power Automate
Hey all, I'm trying to back up my smart sheet important data by copying it into an Excel sheet. The issue is that I get array of rows that should be the column of the row that was copied from smart sheet. See attached pictures. I don't understand why I cannot get a variable for each column in specific row Data On smart…
-
Using a Database to Autofill Cells
Hi Smartsheet Community! I am trying to create a cell autofill for email and phone in one sheet using another sheet as a database. The issue I'm running into is how do you select between identical names with different email/phone. In the database sheet, I've created a duplicate checkbox column with a formula that will…
