-
Copying cards and substasks
Is it possible to copy cards and subtasks in the card view and have the new lines generated in grid view? Make sense? Im trying to copy all subtasks for a new card but just have the user update the main task name. Thanks
-
Help on formula: Return value
Hi all, I am building a project tracker however I am new to creating formulas so please need your help again. Based on the image below, I wanted to get the Stage and the Progress of the project that will later complete my summary report by just displaying the main headers in yellow. On row 1, Stage column, I want to get…
-
Is it possible to display 2 different date range diplays in the Gantt Chart?
Hi, In the Gantt Chart, is there a functionality or a way that we can see 2 different date range displays? For example for a project tracker, 1st date range would be the planned start date and planned end date and the 2nd would be the actual start date and the actual end date so it would look like 2 bars (with 2 different…
-
Help on formula: How to copy adjacent text using a specific text from a different column
Hi all, Please need help on formula. The example image below is a project with sub tasks and I wanted to create a formula in the Progress column highlighted in yellow (this is the main header). The condition is: if the status of the row is "Active", then show me what is its current Progress. Based on the screenshot below,…
-
Filtered Views for External Collaborators
Hello, i am not sure what the best way is to accomplish this. I have a smartsheet that i would like to collaborate with outside vendors. I would like to avoid chopping up the data and giving every vendor their own sheet. I will be adding new data weekly. Update request won't work because they could be getting 20+ lines at…
-
Appsheet
I am meeting with management and IT on Friday to persuade them to use appsheet with our Smartsheet data. I know appsheet is one of the approved integrations but is there any other documentation from Smartsheet that could help make the case for this?
-
How to manage Order with multiple items
I'm creating a form to collect Order information from users and facing a difficulty with an order having multiple items. I want to create a form which allows users to input multiple items in one order request. Each item will have each price and quantity. How can I do that in smartsheet? Thanks.
-
conditional formatting between 2 columns, same row
is there an ability to set a conditional format based on two columns in the same row: completed (column) date is later than the due (column) date – the cell turns red completed date entered is before (or after) today's date
-
Cell Time Stamp
Does anyone know if there is a way to get a Date to generate when a project is set to approved? I want to be able to set a target date using the time stamp from when a concept drawing is approved to when we will need to ship samples.
-
How to use data from another sheet as selection criteria?
Hello, I am trying to build a Report or ANOTHER sheet where I pull data only for Rows from another sheet that have OrderNr=OrderNr from the other sheet. The ordernumbers change daily. I need to be able to refresh automatically on a daily basis. Any recommendations how I should approach this?
