Calculate days since a post opened that stops once a hire date is populated
=IF([Actual Start Date]@row <>””, NETDAYS([Req Open Date]@row, Today()), NETDAYS([Req Open Date]@row, [Actual Start Date]@row))
Hello! I'm trying to calculate # days posted using the formula above but its unparseable. Can someone help tailor and clarify what was wrong?
Answers
-
As for the unparseable issue, your quotes were not the correct character. (”” instead of "")
I believe the logic was reversed, based on your description. This will calculate the number of days between [Req Open Date] and TODAY() if there is no start date. If there is a start date, it will calculate the days between the open date and start date.
=IF([Actual Start Date]@row <>"", NETDAYS([Req Open Date]@row, [Actual Start Date]@row), NETDAYS([Req Open Date]@row, Today()))
-
Hello @AMcElfresh
Are all the columns involved in the function Date columns?
Oddest thing, I had replaced the "" part with "" again and it worked. This is what the results of the function you provided looks like.
This is kind of a circular reference and will never work unless the [Actual Start Date]@row = "". The biggest problem is your conditional statement.
When FALSE, the statement reads like this:
When [Actual Start Date]@row = "" Then
NETDAYS([Req Open Date]@row, [Actual Start Date]@row)
Actual start date is already determined to be blank. There will always be an error if you try to calculate the net days with a blank value.
Split up the functions and this is the result.
Maybe try this and see if it's the desired result:
=IF([Actual Start Date]@row = "", NETDAYS([Req Open Date]@row, TODAY()), NETDAYS([Req Open Date]@row, [Actual Start Date]@row))
Then if the actual start date is blank, the function will rely on today's date instead.
-
Thank you both! Both worked as needed, and that makes more sense.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives