Help converting and excel formula to smartsheet
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
Help Article Resources
Check out the Formula Handbook template!