-
Smartsheet for Jira workflow no longer able to sync
Hi all, I have been using Smartsheet for Jira to share delivery content with customers and also provide project progress reports. However, on April 9th the sync with Jira stopped working. I followed up with our internal IT support and the Smartsheet superusers but I have been unable to uncover what the issue is. The error…
-
Masquer des cellules ou faire des cellules déroulantes.
Hello, Having many small tasks to last, with a repetition, polluting my grid smartsheet by the too many number of tasks. I would like to know if it is possible to do: * A cell with a drop-down menu, where would be grouped, visible to disposition. * Hidden do of rows (not columns) chosen.* Waiting for an answer.
-
Click Drag Attachment from Outlook to Cell
Is there a way to click drag an attachment, such as a .pdf or .jpg image file into a Smartsheet cell from Outlook?
-
Reference another sheet using sheet name
I'm almost certain that there is no solution to this situation, however, here goes. I have a workspace with approximately 35 project sheets. Each project has approximately 50 tasks and each has a schedule status in a "Schedule" column. I want to be able to count these tasks based on their stats and report on the entire…
-
Formula for Summary of Total Tasks and Completed Tasks
There is a smartsheet template set in the solution center called New Employee Onboarding. In the sheet "30 Day Employee Onboarding Sheet" the tasks are organized by Week and By Day. The formulas for counting Completed: # of # are working for each day, but the Cells that have a Weekly Total are not summarizing for the week,…
-
Comments column on web form
I am looking to create a webform that has the comments section. Now from what I have read thus far, it seems impossible to do. That if you want a free flow text field, you need a new column and have it as such: comments. However, some comments can be extensive. And if you wrap teh text, teh smartsheet becomes out of whack.…
-
Cannot sort Card view by Assigned to column
Hello I am using Smartsheet to allocate tasks for projects which i use gantt and grid view for. My team need to look at their tasks allocated to them in card view, but i am not able to sort the card view by the assigned to column I do have multiple contacts enabled in the assigned to column, would this cause the problem?…
-
% Complete is Not Working
Hello, I have a spreadsheet with about 85 tasks and subtasks, the % Complete isn't working. It's show the percent completed as 99%, when only about 10 tasks have been completed for this project. I tried to disable the Dependency Settings and use the =AVG(CHILDREN()) formula but then I got the divide by 0 error. So then I…
-
Reports not listing entries when it should
Hi there, We manage store fitouts. With every project, the sheets are identical. I have created 16 sheets to manage 16 projects. I have just recently added few rows, all identical, on all 16 sheets. When I run reports, it does list certain rows (newly created). Puzzled, I simplified the report to the bare minimum: I now…
-
vlookup w/ resources and dates
We are working on a manpower tracking sheet and trying to create a link from one spreadsheet to another, which will lookup a resource and then find the latest date that resource has tied to it. This will allow us to see when we have someone coming off a project and has not been assigned to another project (on the bench).…