Calculation within IF statement
Hello,
I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise compute the variance:
=IF(ISBLANK([Completion Date]@row), "", =NETDAYS([Request Date]@row, [Completion Date]@row))
This returns "#INVALID OPERATION" on the whole column. I've tried the =IF(NOT(ISBLANK variation with the same result. Is there a way to include formulas within an IF statement? Or is there a different way to accomplish my goal here?
Thanks for you assistence!
Geoff
Best Answer
-
Hi Geoff,
The "=" sign at the beginning, to indicate a function is being entered, is valid for the entire cell. You do not need to repeat it for each function you enter in the cell. If you change "=NETDAYS" to "NETDAYS" it shoud function as you want.
Answers
-
Hi Geoff,
The "=" sign at the beginning, to indicate a function is being entered, is valid for the entire cell. You do not need to repeat it for each function you enter in the cell. If you change "=NETDAYS" to "NETDAYS" it shoud function as you want.
-
That did it, thanks Jacob!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!