Automation to help with Daily Medical Intake Forms


I am having one hell of a time with the automation to help our school with being alerted to different issues facing out compliance with the Daily Medical Intake Forms.

What I am trying to do is have a couple of reports sent but something is not making it run.

Students' parents fill out the med form daily.

Some of the old ones are still blank - Trying to make that part of the report

Some of the dates are not today - Trying to make that part of the report

The one function we can get to work is if certain symptoms or a temperature above a certain point are present.

When an automation runs, does it look through all of the information or just the most recent? I wish there was a tutor program on here to help with specific sheet issues.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!