-
Is there a way to create a list out of joined string in a cell?
I have Sheet A, were I have a column with Task Description that has parents. I created another column where I put the parents corresponding to the child. Example: Parent ID .........|........Task Description [blankcell]........|........Parent 1 [Parent 1].........|............Task 1 [Parent 1].........|............Task 2…
-
Outlook Integration not installing
Inside of Outlook, I have clicked "Store Add-ins", found "Smartsheet for Outlook" and clicked that. I then clicked the blue "Add" button. This then briefly changes to "Adding..." then to "Added". When I go into my Outlook email list, there is no Smartsheet icon. When I go back into "Store Add-ins" and find "Smartsheet for…
-
Does the Project Plan have to be named "Project Plan"
Hi If I have multiple projects, is separate folders, does each project plan sheet have to have the same name, i.e. "Project Plan" in order for links to remain when a new project, project folder is added?
-
Project Settings from Report Glitch
Curious if anyone has issues using the "Project Settings" button (small gear icon in the top right under the share button). We thought we can adjust the project settings for the Gantt view on a report (or does it adjust the project settings for the whole sheet)? Either way, when we click the icon nothing happens. After the…
-
Can I start multiple workflow in the same time and using same form?
I am tyring to make an ERP system. I created workflow to approved from the purchasing department and its department's manager with email. However, i want to add multiple items in the same time and same form to approved(in item code column). How can it possible ? I tried multi select dropdown but workflow does not work.…
-
Can an intake form populate more than just a new horizontal row in a sheet?
I have timeline templates built out in a cascading fashion (with parent and children relationships) using "workday" formulas and a holiday list. I'd like to start the timeline off with an intake form. The customer would enter the timeline type (telling smartsheet which template to pull) and then the start and end date of a…
-
how can add multiple approval request in the same row and cell using workflow?
I am tyring to make an ERP system. I created workflow to approved from the purchasing department and its department's manager with email. However, i can add multiple items in one time to approved(in item code column). How can it possible ? I tried multi select dropdown but workflow does not work. Thanks.
-
Calculating Schedule Health - RYBG
Hello, I am a beginner Smartsheet user and I have listed my set of requirement to track my schedule health task. The requirements are based off % Complete and % Time Elapsed. Requirements below: Tasks that show status of “Complete” - Blue Status in progress, where the % Complete is greater than or equal to Time elapsed. -…
-
Updating "master" task sheet status from six sub-project task sheets
I want to keep task sheets for six projects. I want them to feed to a "master" sheet. I have successfully created the automations to copy tasks as added to the six sheets to the master. Where I am struggling is in updating the master as tasks move from "new" to "in process" to "complete". I don't want to use an automation…
-
What is the best way to connect "predecessors" in SmartSheets to Jira?
My dev team uses Jira, while the project team wants to use SmartSheets for Gannt charts, dashboards, etc. If we create tasks in Smartsheets through templates, how can we carry over "blocked tasks". In SmartSheets, we refer to it as a predecessor", while in Jira it would be a "linked task" as "blocked by". Any insights are…
