Sign in to join the conversation:
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?
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.
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
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?
The column where the formula resides is a Date Formatted column
My manager set up a weekly smartsheets attachment of a sheet to be emailed to them every week. She now wants to turn this off but when her and I go into the Send as Attachment section of the page it only shows that two were sent instead of weekly for the last year or two and there is no way to turn anything off. How do I…
I have a large master sheet that I do not want anyone to have access to except the small team of admins. Is there a way for everyone in a dept to see the projects their dept are involved in (this is defined by a column), but only the PM can make edits to it? Bonus points if we can sort by "Status" then by "Kick-Off Date".…
Is there a way to have a master report that is pulling in the data from all of the necessary sheets and then several minor reports off this one where certain rows can be shown in certain sheets? The reason for this is because as projects get created in the workspace the admin then has to go into 5 reports and link the new…
