-
RGYB Automation
I'm having issues with the following formula and I'm not sure why. Task Formula below: =IF(ISBLANK([Start Date]@row), "Blue", IF([Start Date]@row >= TODAY(), "Blue", IF(AND([At Risk]@row = 1, [End Date]@row <= TODAY()), "Red", IF(AND([End Date]@row <= TODAY(3), [% Complete]@row < 0.75), "Yellow", IF(AND([Start Date]@row <=…
-
Google Calendar
Hello! I am new to smartsheet...learning as I go. I have published my sheet to my calendar, and I have overlayed my calendar to my sheet, however my appointments on my google calendar that is NOT sheet related (ie. speaking engagements, meetings and conferences) is not overlayed onto my smartsheet. My sheet is utilized as…
-
DataMesh & Gantt Charts
I am working on a project that we are trying to DataMesh two individual Gantt schedules into one new worksheet together. I've not DataMeshed too much, but is this possible? I use a formula of "Row # + Site #" as my unique identifier for the config. I set up the config, and the first time I kept on getting errors, so I…
-
Forced dates when dependency is enabled
We are working to importa 1800 line project plan into smartsheet and have run into a dabilitating problem with the dates. What looks to be happening is that the “Duration” and “predecessors” fields are completely driving the dates for the tasks. Anything with a predecessor is automatically forcing the start date to be the…
-
=COUNTIF field has any value
Hello, My current incorrect statement is as follows: =COUNTIF(Plant:Plant, "DC", [Assigned To]:[Assigned To], NOT(ISBLANK([Assigned To]:[Assigned To]))) I am attempting to count the number of fields with any value in the "Assigned To" column with the plant column being "DC". I have made numerous failed attempts to find…
-
Activity status column based on due date and % completion
Team, It will be great if someone can help me to Color Code/Highlight the activities in my smartsheet based on target completion date & % Completion column that is manually updated. What I would like to do is: IF target completion date is in the past & % Completion is less than 100% mark it as “PAST DUE” IF target…
-
Reporting on Tasks Past Due by Person
I'm looking to collect ongoing data/statistics on how many tasks reach past due. I would like to collect this by person assigned and across all projects and then by month. Any suggestions on how to tackle this using smartsheet?
-
Sending a Web form weekly basis
Hello, Does anyone know if there is a way to send a web form on a weekly basis? I have attempted to create an auto workflow but am only able to create an update request. The issue with this is it overwrites the content that was in the row as opposed to adding it to a separate line. If anyone has insight into this, please…
-
% Complete
Hello, I have a project implementation worksheet set up with parent rows and sub-tasks below them. When I enter a % complete for the sub-tasks, it doesn't reflect in the parent row unless all the sub-tasks reflect 100% complete. Is there something I have to turn off/on in order for the parent row to show a true % complete?…
-
Import "assigned to" from excel or CSV
I want to import data from CSV or excel where one column is the "Assigned to" contact. Using the user name or email address smartsheet does not recongnise the data imported untill it is manualy selected in the smartsheet cell. This would then be part of a project imported with resource management using teh assigned to…