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

谢谢你的快速回复。

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.

这是一些学生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.