formula date question

Trish Dillon

Trish Dillon ✭✭✭✭✭✭

09/02/21 in Formulas and Functions

how do i represent this in a formula -date column

i need it to input one or the other...

earlier of April 30 or date in column 2

thanks

Thanks!

Trish Dillon

https://www.linkedin.com/in/trishdillon/

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

09/02/21

Try something like this...
=MIN(DATE(2021, 04, 30), [Column2]@row)

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
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

Formula needed
Hi The numbers are my location in the warehouse Need to have a formule to know how many places i still have in my warehouse. In this example 1 have 2X 0 so means 2 place still free Thanks
Average of Color Symbols (RYG) on same row
I need to be able to create an average (In the Overall Status field) of the 3 filed to the right. As you Can see, they are symbols with the standard stoplight (RYG) colors. I have done this (with the help of the community) for parent/child, but now these fields are on the same row.
I am getting #circularreference and I am not sure how to fix it.
I am trying to get this calculation to work =IF(TODAY() < [Start]@row, "not started", IF(AND(TODAY() >= [Start]@row, TODAY() <= [Finish Date]@row, [% Complete]@row < 100), "In progress - on track", IF(AND(TODAY() > [Finish Date]@row, [% Complete]@row < 100), "in progress - delayed", IF(AND(TODAY() > [Finish Date]@row, [%…