Formula for Start and End Dates in a column

BettyJo

BettyJo ✭

05/15/24 in Formulas and Functions

I'm trying to create a Sheet Summary formula to return the first date in a column and keep getting errors. I can't seem get it to look at the entire column or even a range. I've confirmed the reference columns are all Date columns. Here is the formula I'm attempting and the error I'm receiving.

0 ·

Best Answer

Razetto ✭✭✭✭✭✭

05/15/24 Answer ✓

@BettyJo Hi, Have you tried changing to a Date field instead of text?

0 · Share on Facebook Share on Twitter

Answers

bisaacs ✭✭✭✭✭

05/15/24

Hey @BettyJo,
The sheet summary field needs to be a date field, the formula should work then :).
Hope this helps!

If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
1 · Share on Facebook Share on Twitter
Razetto ✭✭✭✭✭✭

05/15/24 Answer ✓

@BettyJo Hi, Have you tried changing to a Date field instead of text?

0 · Share on Facebook Share on Twitter
Razetto ✭✭✭✭✭✭

05/15/24

0 · Share on Facebook Share on Twitter
BettyJo ✭

05/15/24

Thank you, that helped!

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

Within the last 12 months
I can't get my formula to pull violations reported only within the last 12 months. Can someone see what I am missing? =COUNTIFS({Compliance Master File V2 EE-number}, [EE Number]@row, {Compliance Master File - Compliance Category}, "Reinstatement"), AND({Compliance Master File V2 Violation Date}<=[Today]@row, @{Compliance…
IFERROR and january dates for previous month (and Year)
Happy New Year All. I have successfully had help in navigating the problems of "Previus" month when a new year like now for both COUNTIFS and SUMIFS However, I have a simple IF statement and just cannot get it to work. 4 fields Date & Time - this is the automated date creation value This Month - dropdown with True or False…
Match Multi Values to a Table?
Hello, I am trying to figure out how to VLOOKUP or MATCH or something else to return values from a table. In the example below, in the highlighted row, I would want it to return the three highlighted 'Assigned To' values in the table below. Is this possible? Or is there a better solution that I am not thinking of?