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.

function dates difference

POL GAM

POL GAM ✭

01/29/16 edited 12/09/19 in Archived 2016 Posts

Hello there!

I am trying the function =TODAY() - [starting date]3 and I am receiving this number as result: 86.7854

how can I obtain jus a round number of days?

Tags:

0 ·

Comments

J. Craig Williams ✭✭✭✭✭✭

01/30/16

Pol,

I assume you have dependencies turned on. When you do that, {starting date] becomes a time-date, not just a date.

Try this:

=TODAY() - DATEONLY([starting date]3)

Hope this helps.

Craig

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Has anyone noticed that the source sheet 'link' in an email notification is not a link anymore?
Is this intentional? I can't find any online documentation supporting this change. It appears that the actual 'link' behind the sheet name text has been removed. I'm on board with this because often people click the link and want access when they don't need it. I do still see the link at the very bottom of the email.
Formula help with adding up total $ in one column and associating it to the right business unit
I am having trouble coming up with the right formula for a sheet. I am referencing a sheet to create a formula in another sheet. In the sheet I am creating the formula in, I am trying to calculate (from the reference sheet) the cost by business unit. Here are the two columns I am trying to create the formula for: I need…
Adding formula to help text in Forms
I am looking for a way to display a cell value for the user while they are completing a form; I want to display the current value of an item in inventory that the system thinks we have so the user can adjust it if it is incorrect. For example column = "Gloves", help text would say "We have 6 gloves in stock" and if there…