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 Community Champion

09/02/21

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

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
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 Help - if cell = X then show network days
I hope my explanation makes sense. I currently have a basic formula that shows "networkdays" between 2 dates, however it obviously shows "invalid date type" when the "end date" has not been entered =NETWORKDAYS([Date Open]@row, [Actual Closure Date]@row) . So we want the cell to show "duration to close" when status is…
IF/AND/OR formula help
I currently have a formula that works that checks the red flag if either of these two situations are present; 1. the end date is prior to the start date; or 2. the end date is more than 4 years from the start date. This is the formula: =IF([Target End Date]@row < [Target Start Date]@row, 1, IF(AND(OR(NETDAYS([Target Start…
Creating Report
I want to compare QtyShipped in sheet 3.2.6.2 to the Qty in 3.2.6.1. The QtyShipped in sheet 3.2.6.2 lists the quantities as we ship the parts and Qty in 3.2.6.1 is our contract requirement quantities. Is there a way to sum up the quantities in the QtyShipped in sheet 3.2.6.2 and see that next to the Qty in 3.2.6.1. We…