nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

Mathemathical Operations on Dates/Date Columns

Piotr Pulawski

Hi,

is it possible to perform mathemathical operations on dates/date columns in Smartsheet.

Specifically, can I "deduct" one date from another or somehow calculate the difference (in days) between the two?

Thank you.

Comments

Greg Gates

Yep! Addition and subtraction work on date values! If you wanted to find the number of days between two dates for example, try:

=[Date Column1]1 - [Date Column2]1

Piotr Pulawski

Hi Greg, thanks for your help! I tried that and it didn't work for me at first, but then I played around with the settings of the relevant columns and it now works fine.