-
Can Smartsheet Handle Shifts (Different Working Hours) for Scheduling?
Looking at using smartsheet as a scheduling tool for our project (heavy construction) as it is more mobile friendly than say an MS Project or P6, and the gantt charts actually work as opposed to airtable which has a great interface but their timeline "block" is garbage. We work 2 or more shifts with our crews, so I need to…
-
Calculating Month from Date Column
Hello, I am looking for help with the formula below. I am referencing another sheet and trying to calculate the number of rows that fall within January in the 'Milestone Due Date' column. The dates in the 'Milestone Due Date' column displayed in the following format: mm/dd/yy. =COUNTIFS({Project}, [Primary Column]@row,…
-
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.
