formula date question

Options

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
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
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

SUMIF and NOT Functions
I am working with three formulas to collect data in the Summary. I want to add the NOT Function to these formulas to exclude the rows that are starred in the CCC column. =SUMIF({Region}, "Philadelphia", {Contracted}) =SUMIF({Region}, "Philadelphia", {07/09/25}) =SUMIF({Region}, "Philadelphia", {Difference}) Thank you
Change formatting based on new date input
Background Currently, I am tracking whether a person attended a visit on a certain date and color coding for easy reference. Each row represents a person These dates are at regular intervals, so I'm using a column formula to calculate what the dates should with each each column referencing the column before it as long as…
Edit in report
What do i need to do to make the fields in a report be able to have information added, edited, removed, etc. when the report is open