Formula reference another Smartsheet

Options

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!