Cell Linking and Conditional Statements

Armando Lego

I'm trying to pull information from specific cells based on the date it was entered to a Destination Smartsheet.

I've never dealt with this program. Is this achievable with cell-link + a conditional statement or should I try with VLOOKUP?

L_123

From a specific cell, or from a range of cells based on criteria?

You can use index match to find a specific cell, pretty much the exact same way you would in excel. if you want to perform analysis/reporting on multiple cells based on criteria you can use the collect formula

=sum(collect())

=count(collect())

https://help.smartsheet.com/function/collect