-
IF Statement - If two columns match any two columns on the page, flag it
Right now I have =IF(COUNTIF([Part Number]:[Part Number], [Part Number]1) > 1, 1) If the part number in row matches up with another row, it lights up a flag. I want to be able to add two checkpoints... If a "part number" and "ware" in one row matches up to another "part number" and "ware" on a different row, light up the…
-
Update requests to more than a person
Hi all, I have a spreadsheet that has set up an "Update request". Now, that same update request was set up to notify both myself and my colleague (since i was on annual leave recently, so nothing was getting left behind). What happens is, since there are 2 people in the automation, the update request only gets cleared…
-
Resent Request for Approval
Is there a way to send a reminder to someone who received an automated request for approval? I have program chairs who are either not responding or are not responding in a timely manner, so the Approval Status remains "Requested". Right now, I reset the status so it triggers the automated request for approval again. It…
-
Notifications for when something DOES NOT happen
Hello, We have an important task to do daily at my workplace, and I would like to set up a notification system if the task does not get completed. The idea is that an employee completes the task and then submits the form. If one form is not submitted for the day, an email goes out at X time to notify the supervisor. I…
-
Smartsheet for Outlook imports wrong email date
I am using Smartsheet for Outlook to import emails to rows. The row is created and the email becomes a comment - but the date/time in the comment does not the reflect the real date/time of the email. I have attached a screenshot. Any thoughts?
-
Disable Notifications/Reminders while "building" schedule?
My team and I are getting notifications and update reminders for sheets that I am still building (it is a copy of another sheet I'm using to create a template and it has all the built-in notifications we eventually want). Is there a way to "disable" the notifications until the schedule has been baselined? I don't want to…
-
Custom Message (html) in Automated Workflow
I setup a number of workflows a couple months ago to kick of at the beginning of each month. I've got html within the custom message that worked great for the first couple months. When the notifications were kicked out yesterday, they all show the html tags within the email. Did something happen recently which no longer…
-
Rows being removed
I just realized that a user removed a row from the smartsheet. So I have 2 questions. #1 - Can I keep people from being able to remove a row - while still allowing them to edit information? or #2 Can I set up a notification when a row is removed - so at least I would know when it happened. Any suggestions?
-
Show Conditional Formatting/Cell format on Automated Alerts
I have built an automated alert that determines which columns to include from a large Smartsheet which uses the max 200 columns based on a number of parameters held within certain rows on the sheet. This works well. However the issue I have is that I have conditional formatting contained within certain columns in the…
-
Automatic email notification through forms
I created a form which includes a text field for the person's email address. I want to create a workflow to trigger sending an email to the person when a specific field is changed. However, the person's email is NOT part of the contacts. How can I tell Smartsheets to email the person that a change has been made? There does…