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 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.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
