Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Hi,
I have read some threads but I am still not clear on how LOOKUP is supposed to work.
I know it cannot function across sheets.
But please can someone provide the syntax and basic data?Thanks,Ele
I finally found this. For some reason the search function did not work).
https://help.smartsheet.com/articles/775363-using-formulas#lookup
And I am now again with a problem....when I copy a formula, the range changes...any way to fix it?
Smartsheet's cells allow relative or absolute references.
=Task23
is relative to row 23 in the Task column.
When copied to the row below it, the new formula will reference row 24.
=Task$23
would prevent that - this is an absolute reference to row 23.
Now matter where on the sheet you copy this to, the formula will refence row 23.
=$Task$23
is an absolute reference to the cell at row 23, in the Task column. When copied, the formula will still reference that cell.
($Task23 is also available)
Hope that helps.
Craig
