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

Sumifs
Hello, I was wondering if anyone could help me with a sum ifs function. A screenshot of the sheet is included. Basically I want a formula that says if the course name match and the date match, total the costs. So in the example if the course date is 9/16/2024 and the course name is 300, add the three rows of cost. I can…
How to create a formula column that calculates the difference between rows?
I have a sheet1 with columns labeled "Metric Name," "Plan-Actual," and monthly columns where we record the plan and actual numbers consecutively for the same metric name. Metric Name Plan - Actual Last FY - Jun Last FY - Jul Last FY - Jaug Test-01 Plan 90 89 21% Test-01 Actual 90 79 78 Test-02 Plan 90 100 120 Test-02…
Why is 'DAY' Value from a Date being populated incorrectly?
I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but one is getting the correct day from the DATE. I cannot figure out why 10/08/24 returns 9-Oct-2024. Curious to know if…