Is there a way to set up an automation where an email can be sent to a student as soon a particular column has a number that is less than or equal to 30 and another column has a green symbol? Thank you for your help!
Yes. You will want to trigger on 'When Rows are Added or Changed'. You will also add a Condition to filter to meet your criteria above. Your automation will look like this (be sure to select your appropriate column). Also, in the trigger, make sure you physically select 'Any Value' from the dropdown.
You can notify select individuals or you can change the notifications to Contacts in a cell if you have a contact field.
If anything seems unclear, ask and I'll try to clarify.
Does this work for you?
Thank you for this information Kelly! Is there a way to ensure the email will only be sent once as the column with the number will continue to change (it is a formula that subtracts the current date and the student's first day of rotations)?
Thank you for this information @Kelly Moore ! Is there a way to ensure the email will only be sent once as the column with the number will continue to change (it is a formula that subtracts the current date and the student's first day of rotations)?
That's a good question. I would handle that situation with a helper column - like a checkbox column and a formula to check the box when the value dropped to 30 or below. The checkbox will only be checked once - assuming the value doesn't go above 30 then drop again.
=IF(AND(ISNUMBER([Number column]@row), [Number column]@row<=30),1)
I added the ISNUMBER to try to eliminate blanks and errors.
then I would use this automation
Will this work for you?
@Kelly Moore That could work...could I also add another criteria to that checkbox formula where status column is "green"? I tried putting it in different parts of the formula but keep getting an error. Do I need use a COUNTIFS formula?
=IF(AND(ISNUMBER([Number column]@row), [Number column]@row<=30, Status@row="Green"),1)
be sure to change the column names I used to your actual column names.
@Kelly Moore This works!! Thank you so much!!
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
39 submissions isn't accurate because many of them were just tests. Currently have 3 submissions and would like for it to show 3, is that possible
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.