Formula equivalents from Excel to Smartsheet

Janet Davis
edited 12/09/19 in Smartsheet Basics

We have imported some project trackers and found a lot of Unparseable results.  I am trying to find equivalencies to make my formulas work.  Below is an example.  

=IF(C4=100%,TODAY()," ")  In Smartsheet we tried this, =IF(Progress3=100%,TODAY()," ")

Is there a cheat sheet of sorts?