Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Can Smartsheet to perform a Mod Function?

Matt Laguna
edited 12/09/19 in Archived 2016 Posts

I am a network engineer and I am importing an excel spreadsheet into smartsheet. 

My spreadsheet is an address calculator for quiclky identifying IP addressing for my organization. My spread sheet has the use of the "MOD" function and is contigent upon using this function. 

I am aware that the "MOD" function provides the remainder after division. Is there a way to accomplish this in Smartsheet? 

 

Excel Example:    =MOD(F3,64)*4

where F3 = 296

My spreadsheet returns the following result. 

 =MOD(F3,64)*4    = 160 

 

My work around in smartsheet is such:

=(F3/64)*4 

where F3 = 296

My result in Smart sheet is: 

=(F3/64)*4   = 18.5

 

As seen in my example my work around is not providing the result desired. 

 

Respectfully, 

 

 

Comments

This discussion has been closed.