trying to edit / change a formula to reference different columns
Need to change my column “Expected % Complete” to reference the “Actual Start Date” and “Actual End Date” columns (and not the “planned start date/planned end date columns”)
When I try to replace the column references, I get an “UNPARSED” error
Change from this:
=IF(TODAY() > [Planned End Date (original)]@row, 1, IF(TODAY() < [Planned Start Date (original)]@row, 0, ((NETWORKDAY([Planned Start Date (original)]@row, TODAY()) / (NETWORKDAY([Planned Start Date (original)]@row, [Planned End Date (original)]@row))))))
Change to this?:
=IF(TODAY() > [Actual End Date]@row, 1, IF(TODAY() < [Actual End Date]@row, 0, ((NETWORKDAY([Actual Start Date]@row, TODAY()) / (NETWORKDAY([Actual Start Date]@row, [Planned End Date (original)]@row))))))
Can anyone help correct my formula above?
Answers
-
Any reason you still have that "Planned End Date" in the second formula? (not that this is the problem...)
-
check this out:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!