If two conditions are met, then copy the value.


Hi Smart Team,

I have two sheets A and B, both sheets have similar columns and metrics from two different systems, I want to create a third sheet and collate data as per condition such as if Date=Date and Queue=Queue then copy date for that day. I was able to gather data from System A, from System B, I'm not getting the results.

I have attached the image for reference



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!