- IF Formula with Multiple Criteria
Hello! I have a software enhancement sheet, and I am trying assign priority to each enhancement based on the level of effort (LOE) + change priority calculated score. The LOE can be one of the following: 1 - Unknown, 2 - High, 3 - Medium, 4 - Low, 5 - None The change score change range from 4-25 The breakdown for priority…
- Help to Sort by number and words
currently we have a built in prioritization score based on the data entered on the intake form This will populate either a score of 1-5 OR the word "Tech" When filtering these through the report on our dashboard we want to sort in descending order but want those with the word "Tech" to populate last instead of first I am…
- Can you make a sheet a sub-sheet of another sheet in card view?
我想要一个父”牌视图”heet, and multiple children sheets. The parent sheet would contain all of the cards in all of the children sheets and cards would be able to be edited on both the parent and the child sheet. This would be helpful for organizing cards by project, but allowing us to view cards from all…
- Better looking card view - colors & conditional formatting
Although I am satisfied with a grid view, many others prefer a card view with colorful eye appeal. It would be really helpful to gain engagement if the conditional formatting from the grid view carried over to the card view. Thank you.
- Select and Move Multiple Cards at Once
It would be helpful to be able to select and move multiple cards at once in Card View (using Shift + click and Ctrl + click).
- Customize the one click down for Card View or Gantt View in Reports
When you double click into a card/ gantt line, would love the ability to only show a sub selection of whatever columns were picked in the report vs someone having access to all that's available from the original sheet. Currently when we create reports, we love the clean view of only a few data points in a card view or…
- How do I dynamically update a dropdown list?
I want to create a multi-select dropdown list with all future dates and this will be sent out in a form. Currently, smartsheet only offers a date selector with one max date. I was wondering, is there a way to upload values into a dropdown through an API? Otherwise, can I upload values into a dropdown from another sheet?…
- Multiple Sheets
Hi All, I have created multiple sheets and assigned different individuals to carry out their tasks in their own sheet. While I have set up the automation separately in the back of each sheet to move rows once certain criteria are met and move the sheet (Job) on to its next stage and next employee. I would like my original…
- Is there a way to rearrange sub-tasks under a card once they have been added?
Also, is there a way to pull a sub-task from under a card and move it under another card?
- View settings for shared sheets aren't working
I have created a WorkApp with multiple sheets and reports and from my pov I have the option to toggle between the views Grid, Gantt, Card, and Calendar but I shared it with my team and they are ONLY able to view it from the "default" view setting that I set for that specific sheet/report. Theirs doesn't even have a drop…
