Hi,
I want to know how can I lock a cell in a spatial working formula.
Example:
= IF (AND ({PROJECT CASE TEST Rank 7} = January1, {PROJECT CASE TEST Rank 6} = January2), {PROJECT CASE TEST Rank 8} + {PROJECT CASE TEST Rank 9} * January5, "")
When I pull the formula left, right or down, the cell formula can't blocked and enter wrong argument in next or previous cells
I usually use $ to can block the cells on Excel but on smartsheet I wan to know how I can do same action.
Thanks for your help.