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, pleaseVisit the Current Forums.

删除项目在一个ongoing spreadsheet

Sabrina Christensen
Sabrina Christensen ✭
edited 12/09/19 inArchived 2016 Posts

Is there a way to have the projects on an ongoing spreadsheet be removed or moved to another location so the spreadsheet doesn't become cluttered?

Tags:
· Share on Facebook Share on Twitter

Comments

  • Zac
    Zac ✭
    edited 02/11/16

    By "projects" you're wanting move are you just talking about a row? If so, there a couple ways of doing it.

    1. In the row menu on the left side of the sheet there is an option to move the row to another sheet.

    2. If you have the sheet you wish to move a row or "project" to up top as a shortcut tab, you can click and hold the row number of the row you wish to move and drag it up onto that sheet tab at the top.

    Both options will do exactly the same thing. I have one sheet of current, ongoing projects that I monitor and update. Once the project is complete I move it over to my "Archived List" which is identical to my current list when it comes to columns and layout. This way I still retain information from past projects but don't clutter up my current sheet that I look at regurlarly.

    Note: When moving rows from one sheet to the other, any formulas you have will not carry over, only the values.

    · Share on Facebook Share on Twitter
  • Christian Wells
    Christian Wells ✭✭

    I have a Parent line of Old Projects and then move the Old project below this line and make it a child of the ol project line.

    I can then collapse the line or expand to see it......

    · Share on Facebook Share on Twitter
  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭
    edited 02/12/16

    I do the same as Zac. The columns of hte Current must be the same as the Archive.

    · Share on Facebook Share on Twitter
  • Zac
    Zac ✭

    If, however, you add a column to your current list, whenever you move a row to the archived list that new column will automatically be created. Fun fact.:)

    · Share on Facebook Share on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    If you are moving items to the bottom of the sheet for archiving, be aware that WebForms can be setup to add to top or bottom. If set to bottom, well, that screws up your archive. Or if it doesn't, you need to add your autofill formulas and formatting to the odd data.

    Neither likely a big deal, but possible annoyances.

    I move old projects to templates (don't count as sheets) and archive with the other project documentation.

    Craig

    · Share on Facebook Share on Twitter
This discussion has been closed.

Categories

HI @Jbob<\/a> <\/p>

Thanks for the post. I have tried to recreate your example (in a simple way) to see where the issue is.<\/p>

In mine the column called Date and the column called Max per Value are BOTH Date data types.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

I have exposed the formula I have used in the last column to show how the Max per Value is coming through.<\/p>

I know this has simplified your original question, but can you see how the Max(Collect()) statement works here?<\/p>

Does this help at all?<\/p>

So in yours: <\/p>

=MAX(COLLECT({CQ Hours Data Range 6}, {CQ Hours Data Range 2}, Model@row, {CQ Hours Data Range 5}, Batch@row),<\/strong>)<\/p>

Range 6 and the column you have written this formula into must be Date fields and you have an extra comma where you don't need it! Just between the last two )). This comma will cause an error.<\/p>

Kind regards<\/p>

Debbie<\/p>"},{"commentID":386369,"body":"

Hello Debbie,<\/p>

Appreciate your help, that worked perfectly!<\/p>

Thank you!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":107881,"type":"question","name":"Formula to show duration days in Months, Weeks, and Days","excerpt":"I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns are what I want to calculate with a formula (manually entered now to show what I want to see). For example, if something is 38 days, I want it to…","snippet":"I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns…","categoryID":322,"dateInserted":"2023-07-20T19:40:32+00:00","dateUpdated":"2023-07-20T19:41:46+00:00","dateLastComment":"2023-07-21T12:14:38+00:00","insertUserID":139118,"insertUser":{"userID":139118,"name":"Kayla","url":"https:\/\/community.smartsheet.com\/profile\/Kayla","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w4jS9-j6AyQ!-s9Rt9CEFHw!9QXda4h64Go","dateLastActive":"2023-07-21T12:44:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":139118,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-21T13:30:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":35,"score":null,"hot":3379825510,"url":"https:\/\/community.smartsheet.com\/discussion\/107881\/formula-to-show-duration-days-in-months-weeks-and-days","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107881\/formula-to-show-duration-days-in-months-weeks-and-days","format":"Rich","tagIDs":[219,254,324],"lastPost":{"discussionID":107881,"commentID":386370,"name":"Re: Formula to show duration days in Months, Weeks, and Days","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386370#Comment_386370","dateInserted":"2023-07-21T12:14:38+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-21T13:30:39+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/E719S9G7QZCH\/example.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Example.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-21T00:25:23+00:00","dateAnswered":"2023-07-20T20:20:50+00:00","acceptedAnswers":[{"commentID":386281,"body":"

Try something like this...<\/p>


<\/p>

Months:<\/p>

=INT([Duration Days]@row \/ 30)<\/p>


<\/p>

Weeks:<\/p>

=INT(([Duration Days]@row - (Months@row * 30)) \/ 7)<\/p>


<\/p>

Days:<\/p>

=[Duration Days]@row - ((Weeks@row * 7) + (Months@row * 30))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"}]},{"discussionID":107861,"type":"question","name":"Can I trigger an event when selecting a value from a dropdown list?","excerpt":"Dear all, I have a column with a dropdown list. At the beginning of a project, the value for each dropdown\/task is set to \"Not started\". As soon as the vale for the first task changes, I would like to change another field's value ([Start Date]1) to today's date. But only if it didn't contain a value yet, so I can use it to…","snippet":"Dear all, I have a column with a dropdown list. At the beginning of a project, the value for each dropdown\/task is set to \"Not started\". As soon as the vale for the first task…","categoryID":322,"dateInserted":"2023-07-20T15:52:09+00:00","dateUpdated":null,"dateLastComment":"2023-07-21T12:21:11+00:00","insertUserID":161446,"insertUser":{"userID":161446,"name":"MarkFX","url":"https:\/\/community.smartsheet.com\/profile\/MarkFX","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T09:39:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-21T13:30:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":16,"countViews":44,"score":null,"hot":3379820000,"url":"https:\/\/community.smartsheet.com\/discussion\/107861\/can-i-trigger-an-event-when-selecting-a-value-from-a-dropdown-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107861\/can-i-trigger-an-event-when-selecting-a-value-from-a-dropdown-list","format":"Rich","lastPost":{"discussionID":107861,"commentID":386372,"name":"Re: Can I trigger an event when selecting a value from a dropdown list?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386372#Comment_386372","dateInserted":"2023-07-21T12:21:11+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-21T13:30:39+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-21T09:39:50+00:00","dateAnswered":"2023-07-21T08:29:51+00:00","acceptedAnswers":[{"commentID":386336,"body":"

@MarkFX<\/a> <\/p>

I just replicated your workflow, and it works for me.<\/p>

Can you share some screenshots of the sheet so the columns are visible?<\/strong> (Delete\/replace any confidential\/sensitive information before sharing) That would make it easier to help.<\/p>

Also, do you save after you make the change?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Using MAX to get latest date by criteria

    Hello, I am trying get the latest date in a list, subject to criteria but MAX COLLECT does not seem to work. What am I doing wrong? I have tried both a text column and a date column. =MAX(COLLECT({CQ Hours Data Range 6}, {CQ Hours Data Range 2}, Model@row, {CQ Hours Data Range 5}, Batch@row),) Appreciate any suggestions!

  • Formula to show duration days in Months, Weeks, and Days

    I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns are what I want to calculate with a formula (manually entered now to show what I want to see). For example, if something is 38 days, I want it to…

  • Can I trigger an event when selecting a value from a dropdown list?

    Dear all, I have a column with a dropdown list. At the beginning of a project, the value for each dropdown/task is set to "Not started". As soon as the vale for the first task changes, I would like to change another field's value ([Start Date]1) to today's date. But only if it didn't contain a value yet, so I can use it to…