Calculating 180 days from specific Date column
Hi,
I am trying to calculate 180 days from a date column titled "Hire Date". What does that formula look like? I have tried:
=[Source Data Cell] + [Desired Number of Calendar Days]
=[Hire Date] + [180]
=[Hire Date] + [180 Days]
None of those work :/
Best Answer
-
It's been a long day for me. I see the error.
We were not telling the formula which cell.
=[Hire Date]@row + 180
We previously had just [Hire Date] which told the formula which column but neglected to specify the cell.
@row tells the formula which cell to look at. So we want it to look at the Hire Date column and the cell in the same row as the formula.
Answers
-
When you say none of the formulas work. What is the error message you're getting?
Be sure both the column with the formula and the Source Data cell are formatted as Date columns.
Then your logic of =[Source Data Cell] + [Desired Number of Calendar Days] should work
-
@Summer I am getting the #unparseable error
In place of source data cell, should I be putting hire date, since that is the cell I am wanting the data to pull from? Am I missing quotes anywhere?
-
@Jordan Ionita Please provide the actual formula you're using
-
Try =[Hire Date] + 180
-
@Summer Unfortunately, I still get the same error....
-
It's been a long day for me. I see the error.
We were not telling the formula which cell.
=[Hire Date]@row + 180
We previously had just [Hire Date] which told the formula which column but neglected to specify the cell.
@row tells the formula which cell to look at. So we want it to look at the Hire Date column and the cell in the same row as the formula.
-
Hahahah that worked!! I thought it would be something like that, but was blanking out as well. Thank you so so much! :)
-
@Jordan Ionita I'm glad that finally worked! Don't forget to mark your question as answered.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!