Smart Sheets Form to check if a cell is blank or has a value.

Question

I'm using a Form to enter a daily count by selecting a date and entering a donation value for that day. The form(s) default to one of four locations.  When the date is entered for a default location I want to check to see if the cell to be populated is empty or has a value.  This would eliminate duplicates.

I have a columns for Date, Location, and Donations (numerical value).

Is there a way to validate if a cell (Donations) is empty or populated based on the Date and Location columns?

I am very new to Smart Sheets and this is my first Form.

Thank you!

David Tutwiler · Accepted Answer

I think you're looking for the function ISBLANK.  You would use it like this:

=IF(ISBLANK(Donations@row),1,0)

This is an IF statement that checks to see if the Donations cell on the row you're on is blank.  If it is, then it returns a 1, otherwise it returns a 0.

I'm sure you could use this to modify it to what you're looking for.

David Tutwiler · Accepted Answer

Sure thing. Just add in the donations where the 0 is.

=IF(ISBLANK(Donations@row),1,Donations@row)

David Tutwiler · Accepted Answer

Smartsheets Forms are designed almost purely for "new input".  If there is a weakness with the Form structure it is that it doesn't check the sheet for data and doesn't really have a way to do that.

Sorry, but I don't think that's a scenario that Smartsheet accounts for very well.