If statement and Networkdays function problem
Hi,
I's struggling with a rather simple problem, but thereäs just something wrong with my logic/syntax. Here's the formula, which gives "Unparseable" for me :/
=if([PK]@row = "Siivous", NETWORKDAYS(MIN(Start4:Start13); MAX(Finish4:Finish13))), "")
If there's "Siivous" as the value for a dropdown cell in the PK column, the formula should calculate the networkdays between a Start and Finish date colums for rows 4 to 13. If the valuea for the dropdown is something else, the formula should return empty value.
Any clues highly appreciated :)
Best Answer

Hello @OlliR ,
I think your original formula is very close, would the example below work for you?
=IF(PK@row = "Siivous", NETWORKDAYS(MIN(Start1:Start4), MAX(Finish1:Finish4)), " ")
I hope that is helpful to you in someway,
Protonsponge
Answers

Hello @OlliR ,
I think your original formula is very close, would the example below work for you?
=IF(PK@row = "Siivous", NETWORKDAYS(MIN(Start1:Start4), MAX(Finish1:Finish4)), " ")
I hope that is helpful to you in someway,
Protonsponge

Awesome, it works :) Thank you so much @Protonsponge 💪
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!