Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula For Finding Quarter
Comments
-
I'm having trouble with this one as well. I noticed this was first requested in 2016, is there any update?
I have a column "Expected Delivery Date" (column type is Date)... formatted in MM/DD/YYYY. I'd like to return a text value based on that date for "Expected Delivery Quarter" (so that my leadership can sort in Card View). Quarter should show Q#-YYYY or Q#-YY.
Is this possible? I've tried a million things and have been all over the community to figure it out and I keep getting unparseable errors. Thanks in advance!
-
THIS IS AWESOME AND JUST SAVED MY DAY! Thank you
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 436 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- I'm trying to create a SUMIF formula that looks at the salesperson name in a column and adds up or totals their $ sales in another column. To ultimately show in Dashboard of Totals Sales by Salesperso…
- I have a Dynamic View that is filtered using the "Restrict view by sheet filter" so the view only shows a certain users assigned projects. Each project has one or more resources. The "resources" colum…
- Good day Smartsheet Team, Getting an unparseable error on this formula: =IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"") Trying to pull in a…