Combining 2 Formulas

Hi, I am having trouble combining these 2 formulas:
=NETDAYS([Date Sent To Rep]@row, TODAY() - 1)
=IFERROR([Over Calc]@row, "")
Right now Iย have 2 separate columns calculating, but would like to have just 1.ย
Is it possible to combine these 2 formulas?ย
I want it to calculate the net days, but if there is not a date inputted i want the output to be a blank.ย
Comments
-
Hi Kyle,
Try something like this.
=IF(ISBLANK([Over Calc]@row); ""; NETDAYS([Date Sent To Rep]@row; TODAY()ย -1))
The same version but with the below changes for your and others convenience.
=IF(ISBLANK([Over Calc]@row), "", NETDAYS([Date Sent To Rep]@row, TODAY()ย -1))
Depending on your country youโll need to exchange the comma to a period and the semi-colon to a comma."
Did it work?
Hope that helps!
Have a fantastic day!
Best,
Andrรฉe Starรฅ
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrรฉe Starรฅ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
=NETDAYS([Date Sent To Rep]@row, TODAY() - 1)
=IFERROR([Over Calc]@row, "")
ย
I assume the [Over Calc]@row is a reference to the cell holding the NETDAYS function.
ย
If this is the case, just take the formula that is in that cell (minus the
and drop it in where you have the cell reference in the IFERROR. I do this quite frequently when building out multi-part formulas.
ย
So if the above assumption is true, then it would look like this...
ย
=IFERROR([Over Calc]@row, "")
*insert formula from [Over Calc]@row in place of the cell reference without the =*
=IFERROR(NETDAYS([Date Sent To Rep]@row, TODAY() - 1), "")
-
Thanks for the responses!ย
Paul, your formula at the bottom is the one I ended up using.
Thanks again!
-
Happy to help! (even if I misunderstood)ย
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrรฉe Starรฅ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Happy to help!ย
ย
The formula at the bottom of my post was the finalized solution. The formulas before that were entered as examples to follow along with my explanations.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!