Formula equivalents from Excel to Smartsheet

Janet Davis

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?  

Mike Wilday

Haha. A cheat sheet. I wish. Welcome to the community! We'd be happy to provide you with a cheat sheet. The issue you are facing here is a poorly documented one. Percentages in Smartsheet are displayed in a percentage form but are actually parsed on the back end as a decimal. That being said, when you reference percentages in Smartsheet you will want to use a scale of 0 to 1.  100% = 1. 50% - 0.5. 25% = .25. 

Try, =IF(Progress3 = 1,TODAY()," ")

Do be aware that Today() will add today's date, but it will update that date every day the sheet is opened. It won't put a persistent date, if that's your intention then you're good. Otherwise, you may want to have it write something else instead of Today(). 

Paul Newcome

The closest you'll find is a template. See image below.

Mike Wilday

Here are a couple helps that I reference on a regular basis when I am trying to replicate formulas or troubleshoot errors. Hopefully, one of these will help! 

https://help.smartsheet.com/functions

https://help.smartsheet.com/articles/2476176-formula-error-messages