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!

Date formula calculation acting like string

sschoen1140236

I am troubleshooting a formula using a help example.

My formula is in a date format cell and references a date format cell with a value of 03/01/18

=[DPP Start Date]49 + 5

The result is 03/01/185

What is wrong with my syntax?

Find more posts tagged with

Comments

Mike Wilday

That is bizarre. And shouldn't be showing up like that. I would contact support and find out what is going on. When you say date formatted cell... Do you mean Date formatted column type? If you right-click on the column header, and choose Properties does it show Date or Number as your Column type? It should be set to date.

sschoen1140236

Hi Mike, I meant date formatted columns. It is bizarre because when I try other calculations like =[DPP Start Date]49 + (30*0.4) it returns an 03/01/1812.

If I enter =[DPP Start Date]49 - 5 ir returns #INVALID OPERATION

I will note that I am in a 30 day trial period of Smartsheets

Mike Wilday

I would contact support and see what they have to say. I doubt that being on a 30day trial would be an issue.

Is the column you are pulling the date from a Date Formatted column?

sschoen1140236

The column where the formula resides is a Date Formatted column

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…