Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Alerts for Blank Fields

Syphers
Syphers ✭
edited 12/09/19 in Archived 2017 Posts

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.

Tags:
· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    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. 

     

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories