Alerts for Blank Fields

Syphers

I want to create an alert or reminder when a field on a certain row is blank.  It can't be a required field because the data is entered after the row is created.  Does Smartsheet have this functionality?  I don't see these options available today but thought I would ask if others have attempted this.  I am currently exporting to excel and using a pivot to send data update requests which is very time consuming.

Mike Wilday

I did something similar using an IF formula, 

1. Create a new date column, 
2. Revise and enter the following formula
   
   
   
   =IF(ISBLANK([Column Your Checking to See is Blank Name]1), [Due Date Column]1, "")
   
    
3. Test it by adding something in the column you are checking to see if it is blank. As soon as you enter data in the column the due date should go away. 

Set your alert based on the new date column you created.