Help with changing an entry if a date falls within a date range

Lorri Rose · 2024-06-24 11:31:13

I want to automatically assign our year quarters to a date range so the formula would select Q1 IF date created is between A/B Q2 if date created is between C/D etc - I have no idea where to start can anyone help?

Options

Answers

SoS | Dan Palenchar Community Champion

07/03/24

@Lorri Rose glad it helped!

School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
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

Trending in Formulas and Functions

Formula VLOOKUP or maybe an alternative solution
Hello, I am trying to develop a formula that will reference another sheet and bring back the content from a specific cell. Need to reference two columns for the match in the reference sheet. The match component will come from a column [PI or Account #] on the main sheet to be searched in column 1 on reference sheet and…
Concatenate Formula in SmartSheet
I am in the process of migrating workbooks from Excel to SmartSheet, but am having trouble with the Concatenate formula. I have a column of store numbers and am trying to automatically create the store manager email to be used across different sheets, but I cannot use the concatenate formula in SmartSheet the same way as…
Text to populate when Box is Checked
I need to populate text in a cell when there is a box checked anywhere within a row. This is what I came up with, but it isn't working =IF([Weekend Travel:WeekendTravel]@row = 1, "Weekend Stay")

Help with changing an entry if a date falls within a date range

Answers

Help Article Resources

Categories