-
Agile - Reporting "dead" tasks
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…
-
Cell Linking
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…
-
Conditional calculation?
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…
-
Filter default settings
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…
-
gantt chart - dependencies that are not necessarily SS or FF (or any other combination)
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…
-
Can I use a formula for this date feature?
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…
-
how can i auto populate in smartsheets
I am trying to auto populate a column based on a selection I make in another column.
-
Jumbled Rows
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?
-
UK Contact - Issue with account
Hi, does anyone have a contact number in the UK that works? my account & my whole company is locked out & asked to upgrade when we already have.... this is very urgent!!!
-
Sum total number of cartons by date
I have vendors fill out a form every time they have a shipment leaving their building. I want to create a widget on the dashboard for our leaders that show the total number of cartons leaving our vendors each day. (Bar Graph) But first, how do I create a report or formula to sum cartons by date, without me providing the…