Sign in to join the conversation:
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!
Hello I could use some help with this one. I got the formula to work in the "number column"…. but I cant currently get it to work as a column formula. Basically what I am trying to achieve is have it add a number in order if the "footer comp" column is unchecked. and miss is unchecked Right now it is counting but in the…
I'm need to apply a function to average a column (answer is correct (8)) if the other column (The nurse is caring for a a patient who dove into a) is NOT blank. I copied this over from an excel spreadsheet. I would like to keep the average in the top row. Right now it's saying "#unparseable" as the formula is not the same…
This discussion was created from comments split from: How do I combine multiple INDEX Collect formulas in one Formular?.
