-
Impossible to save rearranged sheet
Yes, we have heavy loaded sheets of our product management in Smartsheet. But we spend so much work in fine tuning the sheets so it is a little bit frustrating, that Smartsheet is not able to save rearranged sheets, after we change the production planing and drag&drop records in a different order. I was hoping that theβ¦
-
Gant Chart Export
Hi all, I am wondering if anyone can help me with an issue I have regarding exporting the Gantt chart. For example, when I create the plan and add all the required elements and select export this to PNG. I am presented with a low resolution, very small gantt chart which does not include all of the details. Ideally I wantβ¦
-
Paste in Visible Columns
Hi, I am looking for feature that's available in excel. I have to copy-paste from one sheet to another. I am copying from colummns 3 consecutvie columns - A, B, C. Pasting in A1,C1,D1 (where B1 is hidden). When I paste it, column A gets pasted in A1, B in B1 and C in C1. Where as I would like it to be pasted in A1,C1,D1.β¦
-
Check box - how to auto record user details once selected
Hi Guys, I am using a checkbox to indicate when a particular task has been completed, but i need it to automatically record the user who changed it and when this occured. Can anyone help me with this, or suggest another way to make this work. Thanks in advance, Brett
-
Subtotal Formula
Hi, I want to take the subtotal of the rows, after applying filter. in excel I was using =subtotal(9, C2:C100), where C2 to C100 are the data field. I tried to apply the same forumula but not working on smartsheet. Is there a way to calculate subtoal of the filtered rows? Please guide.
-
Formulas - Results show an extra 2
I have a very basic SUM formual in my smartsheet. The resulting number is 2 more than it should be. I've cleared the forumla and built it from scratch, and double checked the data in the column. If I handcount, I get the right answer, but the SUM consistently is 2 over. Simiarly, in the next column, I have a COUNTIFβ¦
-
Consolodating multiple sheet info onto a single report line
hi I run a smartsheet where users create smartsheet sheets to plan individual projects. I have a list of all the sheets required. I want to pull a report that compares the list of sheets required with the sheets actually created to track progress. I can create a report which pulls them in as pairs of rows (1 line fromβ¦
-
Android App
Is there Task indent fucntionality in the Android App - if do please advise? Seems to be restricted functionality relative to the Ipad App - hovering over app gives less options on Android v Ipad ALSO certain colums appear locked such as End date and Predecessors why? Really this restricts me from going mobile properly Isβ¦
-
Conditional Date Calculation
hi, I have months columns Aug-2016. .Sep-2016 etc., (just the names of the Column are months, but the Column property is Text/Number) and each month has a number value. I'd like to be able sum those numbers based on a condition - The current month's number + 4 more months from the current month should be summed. Eg: Whenβ¦
-
Dynamic Dates
I am creating task reports for our team that pulls tasks from multiple sheets and aggregates them into one, easy to read report. I'm using reports because I want to apply date filters and structure task reports to show all outstanding tasks (past due and due today) and upcoming tasks (tasks due within the next week). Iβ¦