Sign in to join the conversation:
Hi Everyone, Is there such a thing as an "if" statement then link cells?
If cell has check mark link these cells to a different sheet.
The only way I am aware of is to write an IF statement in the "different sheet". Unfortunately that would require setting up a new range for each cell and writing the individualized IF statement for each one as well.
=IF({Sheet 1 Checkbox Cell Range 1} = 1, {Sheet 1 Data Cell Range 1})
For the Checkbox Cell Range 1 you would "Reference Another Sheet" and select the checkbox in that specific row.
Data Cell Range 1 would be the data cell in the same row as the Checkbox.
Because you are referencing another sheet you will have to rewrite the IF statement in the row below it, referencing the first sheet and selecting new ranges (Checkbox and Data for the next row down) for each row on the target sheet ("different sheet").
The limitation with that is you can only have 100 unique sheet references per sheet. Since you already have 2 for each row, that would limit you to being able to pull data from only 50 cells.
If you are using this on a small scale project, it may not be too terribly tedious, but it could be rather excruciating in larger projects.
Hope this helps...
Paul, can the values be set in a row on the linking sheet and referenced as variables in the IF statement? This would prevent having to write each IF statement individually.
-J
Possibly. It would depend on exactly what you want and whether or not that type of format would work for your particular project.
If you are able to provide some specifics and some screenshots, we might be able to help you out a little better.
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Currently Triggering recurring workflows are only supported at the top of each hour. For instance 10:00, or 11:00, etc. Would like the ability to set 10:30 or 10:45. Perhaps the inteface can stay hourly so it doesnt get huge, but have the ability to manually edit the time directly to any custom time.
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
