-
VLOOKUP Formula Help Needed
I have a VLOOKUP challenge :) 1st sheet is a project portfolio and capturing project names and a project status in a traffic light system. On another sheet I want to calculate all the "green", "yellow" and "red" amounts in out portfolio. No issues there, but if I want to create a formula to get automatically all the names…
-
Complex IF AND Formulas
I'm trying to automate the RYG circles according to several columns of a Smartsheet grid for project management purposes. The logic is below (I've also attached a visualization of the logic): IF [Proposed Product Launch Date] <TODAY, "Gray" IF [Proposed Product Launch Date] >=TODAY AND [Deviation from Proposed Launch Date]…
-
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…