Convert excel date formula to Smartsheet

Sidonia Posteuca

How do I recreate this formula in Smartsheet?

Kelly Moore

Hi Sidonia

You have a few options but to recreate it exactly as written, assuming your smartsheet column names are named exactly as referenced above

=([Year End]@row-Eligible@row)/7

The easiest way to ensure the correct cell syntax is to click in the cell desired while writing the formula, and smartsheet will insert the right column name and row reference. You might find this information helpful.

https://help.smartsheet.com/learning-track/get-started/formula-basics

cheers