Formula reference another Smartsheet


I am trying to create a smartsheet referencing an existing smartsheet. Here is the formula that I am wanting to do:

This is for the name column of Smartsheet B

=If (Smartsheet A) start date is greater than 3/1/2021, then name on Smartsheet A

If have tried this, but get the message #INVALID OPERATION

=IF({On-Boarding Employees Range 1} > DATE(2021, 3, 1), {On-Boarding Employees Range 2})

Thanks for your help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!