-
Is it possible to grant access to a folder without granting access to the whole workspace?
Im hoping someone can help me out, I am fairly new to SmartSheets. In my organization, we have created a Workspace called PMO - Projects. This workspace has a folder for each department and within each department there is a folder for each project we are running specifically for that department. We have configure this to…
-
Issue with COLLECT and duplicate dates
We are trying to achieve a formula that finds the most current Tracked task's Variance from the Baseline date. Tasks are arranged in a table/schedule in step by step order. I'm having an issue with this formula here: =INDEX([Baseline Variance]5:[Baseline Variance]128, MATCH(MAX(COLLECT([Task Complete Actual]5:[Task…
-
How to merge cells?
Is it rellay cannot merge cells in smart sheet???
-
Formula Help
Hi, Are you able to help? I have a column named "snag" which is a red flag check box, then another column named "PM" with drop down name initials I need a formula that calculates, when a Red flag is raised and PM name is "XYZ" the result is = ZZ number of projects I'm going wrong somewhere and can't get it right, see…
-
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.…
