-
Send an Update Request at a Specific Time on a Specific Day
I have read several post regarding the ability to control an update request / timing. I have tried this multiple ways. 1) Created a Form - I struggled with the team picking the correct date (this was necessary). I setup a Outlook Calendar Reminder weekly so it would remind them at a specific time. When they submitted the…
-
Feature requests: More formatting options on Gantt
Hi folks, Not sure where this belongs, but I figured I'd post it here as I haven't seen a post that captures the overall formatting power of the Gantt chart. I would love to see more robust text and other formatting on the Gantt chart. As a longtime MS Project user, i was able to create really slick milestone charts and…
-
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…