IF statement to pull value from another sheet if a checkbox is ticked

Kyle Furner
Kyle Furner ✭✭
edited 12/09/19 in Smartsheet Basics

Hi all,

 

I'm trying to have a link between a risk register into an issues register and I don't know if it's simply my code or if this isn't possible in smart sheets.

I have a column in my risk register with a checkbox that gets ticked when a risk has become an issue. 

I want my issue register to have a column listing the associated risk ID.

I want the cells in this column to essentially look at each risk row and pull the Risk ID into the issue register only if the box has been ticked. 

I have a single column range for the Risk ID column and another single column range for the check box column. My code is below but I keep getting errors.

=IF({Risk checkbox range}2 = 1, {Risk ID range}2,0) 

The formula above returns the #UNPARSEABLE error

=IF({Risk checkbox range} = 1, {Risk ID range},0) 

Removing the row number returns #INVALID OPERATION

If I just link to the checkbox cell, it returns "true" if ticked and nothing if unticked.

If I replace the '1' in the formulas above with "true" it makes no difference to the errors I receive.

 

Any help would be greatly appreciated. 

 

Comments