eganji ✭✭✭
edited 12/09/19 in Formulas and Functions


I have a formula that works perfectly in Excel but I can not get it to work in Smartsheets. I am having issues finding corresponding functions in Smartsheets. This is the formula and screenshots show what I am getting from them.


Any ideas?

Screen Shot 05-30-19 at 02.31 PM.PNG

Screen Shot 05-30-19 at 02.40 PM.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!