How do I set the base date

Lottieloca

Lottieloca ✭✭

10/10/23 in Formulas and Functions

I am setting up a sheet. It thinks the year is 2018. How do I make smartsheeet know it's actually 2023?

thank you

0 ·

Answers

Julie Fortney Overachievers

10/10/23

@Lottieloca Where are you seeing the year 2018? Can you provide a screenshot?

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 in Smartsheet that will tell me if the data in 4 different columns is the same
I am looking for a formula in smartsheet that will tell me if the data in 4 different columns is the same. In excel I am able to use =COUNTIF(A3:D3,A3)=4 In Smartsheet I am getting "INVALID COUMN VALUE"
Formula to summarize data from symbols column for same row ID
This discussion was created from comments split from: Countifs formula with and/or criteria across multiple columns.
Help with ISBLANK on column formula
I am stuck getting this to work and have been trying both ISERROR and ISBLANK but keep getting an UNPARSEABLE error. Here is the overview of what I need to do: First, I have a column [Cumulative Delay for Start Date] that increments based on other values for a row. The second column is the base starting date [CALC DATE]…