COLLECT date values from another sheet

There are 2 sheets with the same set of columns:

Code / Crop / Start / End / Cost

Start and End Columns are dates.

1) I need to collect date from column Start which satisfies the conditions Code = 1122, Crop = Apple. The formula is the following: =COLLECT({Sheet1 Range 1}, {Sheet1 Range 2}, @cell = Code@row, {Sheet1 Range 3}, @cell = Crop@row), where Range 1 = Start:Start, Range 2 = Code:Code, Range 3 = Crop:Crop.

Why it results #DATE EXPECTED?

2) I need to collect values from column Cost which satisfies the conditions Code = 1122, Crop = Apple. The formula is the following: =COLLECT({Sheet1 Range 4}, {Sheet1 Range 2}, @cell = Code@row, {Sheet1 Range 3}, @cell = Crop@row), where Range 4 = Cost:Cost, Range 2 = Code:Code, Range 3 = Crop:Crop.

Why it results #INVALID COLUMN VALUE?


Thank you in advance.

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!