Use a checkbox to toggle a formula that = the cell above.

Jerry Alexander

I'm wanting to use a formula to populate a cell with the information in the cell above if the checkbox is selected.

=IF([Request Sign Off]5 = "1", =Address4, " ")

in this formula, Requested sign off is a checkbox, and Address 4 is the cell above.

Andrée Starå

Hi @Jerry Alexander

Unfortunately, it's not possible because the Address would break the formula pattern so it wouldn't continue to auto-fill the formula, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

We could maybe structure something with so-called helper columns, but it would break the group if something else submits in between.

Make sense?

I have an idea. FYI. (I've emailed Eileen as well)

Would it work to have everything on one row/form instead for each submission?

How many rows can there be as a max do you think per submission?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Stefan

Hi @Jerry Alexander ,

from the description of your use case I think you should probably go with the solution Andrée suggests.

Regarding your error "unparsable"

this time the = before Address1 is wrong and after Address1 a comma is missing.

Hope this helps

Stefan

Stefan

Hi @Jerry Alexander ,

try this:

=IF([Request Sign Off]5 = 1, Address4, "")

Hope this helps

Stefan

Jerry Alexander

Thanks @Stefan , but this is what I had first. it returns a #INVALID OPERATION

Stefan

Hi @Jerry Alexander ,

hmm, it works in my sheet.

Sometimes Smartsheet seems to not like copied formulas. Would you mind typing the formula into your cell and check, that the parts of the formula are coloured?

Greetings

Stefan

David Joyeuse

Hi @Jerry Alexander

Try removing quotes around 1 in your formula. Quotes means text for smartsheet, while checkboxes requires numbers.

Jerry Alexander

@Stefan I'm wanting to copy what is in the row above to the row where the formula is. I did write out the formula, (rather than copy paste). if the check box is selected, I'm wanting the address 1615 Wheeler Unit D to copy down to the next row.

Jerry Alexander

@Stefan @David Joyeuse

I'm going to make an attempt to explain the use case, I hope I can do this so you can follow.

My end use case here is to be able to enter data (a list) into a sheet through a form without having to enter repetitive data (customer information). I figured out that I can have one form open another form when submitted, but from a data perspective, the customer information (form 1) and the list data (form 2) will not have the unique identifier to associate the customer row, with the list rows. If multiple customers submit, you dont have anything on the "list" that tells you what customer its linked to other than the order (created by).

the effort was to add a check box (default in the form) on the list entries. then the formula would copy the address for every entry and be broken when a new customer information form was submitted (with no checkbox). since smartsheet looks at the two previous rows to copy formulas, I was hoping this solution would work.

Thanks for the effort to this point guys

Andrée Starå

Hi @Jerry Alexander

Unfortunately, it's not possible because the Address would break the formula pattern so it wouldn't continue to auto-fill the formula, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

We could maybe structure something with so-called helper columns, but it would break the group if something else submits in between.

Make sense?

I have an idea. FYI. (I've emailed Eileen as well)

Would it work to have everything on one row/form instead for each submission?

How many rows can there be as a max do you think per submission?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Stefan

Hi @Jerry Alexander ,

from the description of your use case I think you should probably go with the solution Andrée suggests.

Regarding your error "unparsable"

this time the = before Address1 is wrong and after Address1 a comma is missing.

Hope this helps

Stefan