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

Jennifer Dewhurst
Jennifer Dewhurst ✭✭✭
edited 12/09/19 in Archived 2016 Posts

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.


This discussion has been closed.