Is there a formula that will work for this?


I'm trying to pull a start date from a sheet into the sheet summary if the bucket is a certain bucket:

I've tried the below formulas but keep getting #UNPARSABLE:

=IF(CONTAINS("1.2 WON", Bucket:Bucket), COLLECT(Start:Start, @row))

=IF(bucket;"8.1 CURRENT DUE DATE",(VLOOKUP(xx/yy/zzzz,start:start, 8))

The bucket doesn't rest on the same row for every sheet, thus the need for a formula that will search one column and return the data from the same row in a different column.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!