Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
If/OR formula
I can't see where I went wrong; I am trying to get two columns to calculate the number of days between two dates when one of the fields is "N/A". Here's what I have so far:
=IF(OR([Initial Approval]1="",[Request for PR]1="",[Initial Approval]1="N/A",[Request for PR]1="N/A"),=(NA(),[Request for PR]1-[Initial Approval]1+1)
The lowest number the result can be will be 1. What am I doing wrong? Any guidance given is greatly appreciated.
Thanks all.
Comments
-
Hi,
Shouldn't it be the following?
=IF(OR([Initial Approval]1 = "", [Request for PR]1 = "", [Initial Approval]1 = "N/A", [Request for PR]1 = "N/A"), "N/A", [Request for PR]1 - [Initial Approval]1 + 1)
This will return N/A if any of the dates is empty or calculate the difference if there are dates in both.
I hope that helps.
-
YES!! Thank you so much!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K 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
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives