Welcome to the Smartsheet Forum Archives
这个论坛的帖子不再监视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, pleaseVisit the Current Forums.
Archived 2017 Posts
Discussion List
Categories
Popular Tags
- Formulas10,447
- Project Management4,334
- Sheets3,653
- Reports2,546
- 形式2,319
- functionality2,110
- Automations1,755
- IT & Operations1,744
- Support1,520
- Cell linking1,508
- Enhancement Request1,487
- Email Notifications1,377
- Account and User Management1,372
- Integrations1,212
- Conditional Formatting1,184
- Dashboards1,166
- Construction1,085
- API and Developers884
- Sharing and Collaboration874
- Manufacturing862
- Update Requests799
- Workflows in Smartsheet777
- Gantt View775
- Product Development768
- Attachments763
You should be able to see this in the Activity Log (if you have access), but the other giveaway will be that will data in the similarly named columns but not the original ones.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107483,"type":"question","name":"Need Help with Nested IF Formula","excerpt":"I am trying to have a value returned in a column if the date in another column is between two dates. Example: I want 1Q23 value returned if the date in Column A is between 1\/1\/2023 and 3\/31\/2023. I started with the following nested IF formula but it keeps on coming back as unparseable. =IF(AND([Go Live Production Date]@row…","snippet":"I am trying to have a value returned in a column if the date in another column is between two dates. Example: I want 1Q23 value returned if the date in Column A is between…","categoryID":322,"dateInserted":"2023-07-11T23:26:05+00:00","dateUpdated":null,"dateLastComment":"2023-07-12T12:46:46+00:00","insertUserID":141549,"insertUser":{"userID":141549,"name":"Ro W","url":"https:\/\/community.smartsheet.com\/profile\/Ro%20W","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xUNeseKV6XQ!6ftROmCmafQ!1rf1SM1_frg","dateLastActive":"2023-07-12T14:20:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":141549,"lastUser":{"userID":141549,"name":"Ro W","url":"https:\/\/community.smartsheet.com\/profile\/Ro%20W","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xUNeseKV6XQ!6ftROmCmafQ!1rf1SM1_frg","dateLastActive":"2023-07-12T14:20:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":40,"score":null,"hot":3378285171,"url":"https:\/\/community.smartsheet.com\/discussion\/107483\/need-help-with-nested-if-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107483\/need-help-with-nested-if-formula","format":"Rich","lastPost":{"discussionID":107483,"commentID":384778,"name":"Re: Need Help with Nested IF Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384778#Comment_384778","dateInserted":"2023-07-12T12:46:46+00:00","insertUserID":141549,"insertUser":{"userID":141549,"name":"Ro W","url":"https:\/\/community.smartsheet.com\/profile\/Ro%20W","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xUNeseKV6XQ!6ftROmCmafQ!1rf1SM1_frg","dateLastActive":"2023-07-12T14:20:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-12T12:43:44+00:00","dateAnswered":"2023-07-12T08:57:36+00:00","acceptedAnswers":[{"commentID":384741,"body":"
Hey, <\/p>
<\/p>
You have one too many closing parentheses in your formula.<\/p>
=IF(AND([Go Live Production Date]@row >= DATE(2023, 1, 1), [Go Live Production Date]@row <= DATE(2023, 3, 31)), \"1Q23\", IF(AND([Go Live Production Date]@row >= DATE(2023, 4, 1), [Go Live Production Date]@row <= DATE(2023, 6, 30)), \"2Q23\", IF(AND([Go Live Production Date]@row >= DATE(2023, 7, 1), [Go Live Production Date]@row <= DATE(2023, 9, 30)), \"3Q23\", IF(AND([Go Live Production Date]@row >= DATE(2023, 10, 1), [Go Live Production Date]@row <= DATE(2023, 12, 31)), \"4Q23\", \"//www.santa-greenland.com/community/categories/c2017/\")))))<\/strong><\/p> There are 4 IF's and 5 closing parentheses.<\/p> I removed 1 and it worked perfectly, well done on a great formula!<\/p>
![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/BMG012PYBC0B\/screenshot-2023-07-12-095715.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
