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

Larry Callan

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

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

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

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

David Tutwiler

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.

David Tutwiler

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.

Larry Callan

Thank you for the fast reply.

If the cell is blank it returns a 1. Is there a way to return the value that is in the cell instead of the 0?

David Tutwiler

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

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

Larry Callan

Thank you, David.

What I working on is having the end user enter a donation total for an entered date. I would like the form to "check" if the donation cell is empty or already populated. The end users form is set to default to his/her location and when they selects a date I want the Form to allow or not allow the donation total to be entered based on if it is empty or populated.

Is this something SS can do?

Can you suggest a solution?

Thx in advance,

Larry

David Tutwiler

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.

Larry Callan

Thank you.