Help converting and excel formula to smartsheet

Options
rfgala
rfgala
edited 12/09/19 in Formulas and Functions

Hi everyone,

 

I'm pretty new to smartsheet so I may be asking your help for something that is quite easy to do :)

 

I have an excel formula that I need to migrate to smartsheet to help me transform seconds in HH:MM:SS

 

The excel formula is =TEXT(IF(I4="";50;I4)/(24*60*60);"hh:mm:ss") & ":00"

 

Is there a way to use the same formatting logic in smartsheet?

 

Thank you so much for your help

 

Rafael

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!