Formula works in Excel, but not in Smartsheet

System Employee

11/08/23 in Formulas and Functions

This discussion was created from comments split from: Formula will function in Excel but not SmartSheet.

0 · Share on FacebookShare on Twitter

Answers

• 

  DAN S Goombazz ✭✭

  11/08/23 edited 11/08/23

  Hi am wondering if this excel formula below will work in Smart Sheets. I am doing some research of my boss in regards to tracking KPI's.

  
  

  

  

  
  

  0 · Share on FacebookShare on Twitter
• 

  Trish Dillon ✭✭✭✭✭✭

  11/09/23

  https://community.smartsheet.com/discussion/comment/404042#Comment_404042

  
  

  Yes - you would have to reformat the formula to make it work in Smartsheet but those functions are available in smartsheet.

  Thanks!

  
  

  Trish Dillon

  https://www.linkedin.com/in/trishdillon/

  0 · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list