Hoping you can help with the below formula. I need to return zero and can not get the iferror formula to work. current formula is =NETWORKDAYS([Agreement Effective Date]4, [Actual Go Live]4). Screenshot included for reference.
Thanks,
Heather
Hi Heather,
The screenshot doesn't show the columns mentioned.
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Hi Andree,
The screen shot was attached to my original post. I am looking to replace the error message with a 0 when both date fields are not populated. This will most likely occur in column "actual go live" column.
You can just use an IFERROR statement like this...
=IFERROR(NETWORKDAYS([Agreement Effective Date]4, [Actual Go Live]4), 0)
Happy to help!
Try something like.
=IFERROR(NETWORKDAYS([Agreement Effective Date]4, [Actual Go Live]4),0)
Did it work?
This was perfect. Thank you!
Excellent!
I am wanting to calculate Netdays but only if there is data in 'Corrective Action 1' I am currently using this formula: =IF(ISBLANK([Date Action 1 Complete]@row ), NETDAYS([Date of Event]@row , TODAY()), NETDAYS([Date of Event]@row , [Date Action 1 Complete]@row )) How do I adjust it to only pull a date when Corrective…
I have Concept phase projects that can result in multiple Phase 1 projects being generated from one Concept Review. I want to calculate the time in the Concept Phase for the first project from that Concept (the Approved Gate 0 UID), but mark it N/A for any subsequent references to that UID. I figured out the formula below…
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
