Hello everyone, I am on the trial version, testing to see if it will work for my company. I loaded a spreadsheet from Google Sheet, and I am trying to hide some rows. I clicked everywhere and wasn't able to find. Would somebody please help me? Super thanks in advance!
Hello, I am new to Smartsheet and agile and am looking for best practices. If you plan a task for the sprint and it suddenly is stopped or placed on hold, what is the proper way to record this? Should you simply delete the task from that week's sprint? Perhaps add a status called "Dead/On Hold"? When it's outside of your…
I have watched many videos but cannot seem to master the cell linking between sheets. I've tried multiple ways but never receive the results I'm looking for. I have a project on a sheet Named Eblasts and it has subcategories of Months of Year and then Tasks subcategorized under that. I would like to link the whole Eblast…
I am trying to create a formula that will calculate sales commission based on which marketer is named in another column. I have two marketers who are at different commission levels. I would like the Commission column to automatically calculate the commission total from the dollar value in the Services column, based on…
I use up to 5 sheets at any one time, each containing information relating to different customers. I frequently need to filter information on any particular sub-client via a text/number column. The default ‘Create New Filter’ uses “contains” for me to enter a unique name of the sub-client, and all rows applicable to that…
I have a project where Activity A is anticipated to run for a month. And Activity B starts around the same time, maybe a little later (start date is independent of A).. however B can NOT be closed out until A is complete.. AND B has a hard stop due date. how do I set THAT one up? cuz I don't want B to automatically shift…
I'm working on transferring my excel system into smartsheet. I am creating a newsletter regarding events that happen during a certain period. In excel I can use a forumula based on a date. For example if the publish date is 23/5/2018, it will relate to events happening between 24/5/2018 and 3/6/2018. In excel , the event…
I am trying to auto populate a column based on a selection I make in another column.
I have a Sales leads sheet shared by 4 of us. Almost every time I move or amend a row and then SAVE, the rest of the leads jumble around and I have to move every thing back. Not sure what's the problem here! Can anyone help?
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…