Networkdays formula syntax error
I used the AI formula builder to create a formula to calculate the number weeks (weeks out) between a launch date and milestone dates. I want the weeks out to always be positive. When I try to convert the provided formula, which works in the cell I place it in, I get a syntax error. I can't figure out the error.
Answers

Your formula is referencing a specific row using [Date]72  this means the value in the Date column on row 72.
You cannot reference a specific cell in a column formula. If you make this a cell formula, it should work.

Ok so I added another column Launch Date and copied the same date on each row. It now is allowing the formula to be converted to a column formula now that I am referencing the date@row. Thanks for the help.
=IFERROR(ABS(NETWORKDAYS([Launch Date]@row, [Milestone Date]@row) / 7), "")

Great news @PDunn
I know it is working now and you might not want to mess with it, but if the launch date is the same for every single row and you don't want to have that extra column, you could make launch date a field on the sheet summary and then reference that in your column formula. See
if you are interested.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 360 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!