-
Sorting by Date in Exported Excel File
When I export a sheet (Gantt Chart with timelines) to Excel it doesn't seem to sort (e.g. by date) all the rows when indented Task Names are present. It will only sort the highest level Task Name, but I would like to sort all the rows regardless of the Task Name hierarchy. Is there a solution to do this, or possibly a…
-
Inconsistent Formula Function (seemingly, anyway)
I wrote a formula to calculate the number of days until a task is due. It works perfectly most of the time, but, on some rows, it doers not. Below are the actual copied and pasted formulas from the cells that say "OVER-DUE" and "-2, referenced from the screenshot: =IF([Task Total Hours]26 = 0, "", IF(Finish23 < TODAY(),…
-
Formula to check Child Row checkbox if Parent row contains "ABC Dept" (filtering by Department)
I have a "Master" project resource sheet with great grandparent rows for "Current Projects" and "Future Projects", Then grandparent rows for each "Project", parent rows for department and child rows for the individual resources per department. I'm trying to create a filter to filter resources by department across…
-
Smartsheet template with approval request
Hello, We will need to create multiple number of sheets periodically and thinking of creating them from a Template. The sheets will be quite basic/plain - mainly contain free text, drop down list, number and dates. I am quite sure this can be accommodated by the template. Can the template also cater for Approval requests?…
-
Send Weekly Request to Complete Survey
I am interested in sending each of my team members a weekly Temperature Check survey. I created a new sheet to collect their responses, and a form with the questions. I believe i have an automated workflow set up so that an alert is sent to each team member every week at 2:00 pm on Fridays. In the Message, I included a…
-
Unhide row
I need to retrieve a row in a master smartsheet. I can see that row in a report output, but cannot see it in the source sheet. In the master sheet row number jumps from 266 to 268 and it's 267 that I need. On the other hand, you can't hide, and therefore unhide rows as such, the only thing I can think of is that I may have…
-
Alphabetize Filter Options
In one of my sheets, I can create a filter for the field "Project Manager" In the field(s) Show columns that match...if I click the dropdown arrow to give me the options for selection, I do, in fact, see a scrollable list of project managers - out of order - How can I alphabetize this list?
-
Auto Populate second sheet
Hi, I have a main sheet with a form. As you know, every time a user submits a form, a new row appears. I was wondering if there is any way to have a separate sheet that connects to the main sheet so when a new entry is added through the form on the main sheet, a column is updated on the second sheet reflecting the new…
-
Prevent a milestone from moving, regardless of predecessors? (flexible lag time)
I have a milestone date in my timeline (0 day duration). I would like to link it to a predecessor that is currently scheduled to finish a few days before the milestone, however, when I add the predecessor (Finish-to-Start), it moves my milestone date! (Moves my milestone date earlier, to occur the day after my predecessor…
-
Formula to count fields that are not blank
I am just getting familiar with smartsheets and am having a problem convert a spreadsheet that contains a formula that I really need. This formula currently works well in Excel to count cells that contain dates so if any cells are blank it won't count the cell. This is the formula that works in Excel…