IF OR with an IS Date?

Catherine Shea

Catherine Shea ✭✭✭

03/31/22 in Formulas and Functions

Looking for some support on this

0 ·

Best Answers

Dale Murphy Community Champion

03/31/22 Answer ✓

@Catherine Shea Try:
=IF(OR((ISDATE([Date 1]@row)), (ISDATE([Date 2]@row))), "We have a date", "No date")
dm

0 · Share on Facebook Share on Twitter
Catherine Shea ✭✭✭

03/31/22 Answer ✓

Thank you Dale!

0 · Share on Facebook Share on Twitter

Answers

Dale Murphy Community Champion

03/31/22 Answer ✓

@Catherine Shea Try:
=IF(OR((ISDATE([Date 1]@row)), (ISDATE([Date 2]@row))), "We have a date", "No date")
dm

0 · Share on Facebook Share on Twitter
Catherine Shea ✭✭✭

03/31/22 Answer ✓

Thank you Dale!

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Automatically Create Status based on completed check column and finish date
I want to have a formula in my status column that makes the status "overdue" if completed column is not checked and finish date is in the past and "on schedule" if otherwise. The formula I have below is giving me a circular reference error. Current Formula: =IF(AND(Completed@row = 0, Finish@row < TODAY()), Status@row =…
Index Max / Children
Hello community, I need a formula that will return the most common value of its children. In the photo below. There are two expanded lists (Chatham and Patcham). I want my formula to capture the most common nature of issue for each location. In this example, Chatham should return 'Power Isolation Process' and Patcham…
INDEX COLLECT MAX
=INDEX(COLLECT({Nature of Issue}, {Nature of Issue Count}, MAX({Nature of Issue Count}, 1), {Site Name Helper}, Site@row), 1) Hello, community. I am trying to solve following. I want my formula (above) to return the nature of issue that has the most common nature of issue count for each site {Site name helper}. It is not…