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

SUM from another sheet based on the week
I have a reference sheet that each row could be a different day. I need the sheet I'm working on to sum the number of findings based on the week. Here is the reference sheet (there are many more dates not shown in the screen shot) Here is the sheet I need to sum the findings. The formula I attempted is in the screenshot.
Help with a checkbox triggering a formula
I have an order form that I'm creating. I have these three fields here in question. Item 1 (Checkbox) Item 1 Qty (Number Amount) Item 1 Price (Formulated box that when Item 1 is checked and they put 2 in the Qty, it multiplies it by the price of the item) I have written this formula and came up empty. Tried a few different…
How do I reduce cross-sheet references? My sheet tells me I have reached the max. number