- Report Doesn't update status from sheets
I have a report pulling status from different project sheets and notice that the Status (R, Y, G) does not automatically update in the report. I have to open and close each underlying sheet for the status in the report to be updated. My report is pulling information from 100+ sheets. The status column in each sheets uses…
- Auto Fill some form fields from previous form submission
Is there a way to auto-fill some fields in a form from the previous form submission? We use a form to capture actions by Project and Project Manager and would like for the Project and Project Manager information to be captured from the previous form submission, so that only the actions and due dates have to be entered for…
- Planned Dates appear on days defined as non-working days in Smartsheet
We have defined holidays and non-working days in the Project Settings, but noticed that Smartsheet still shows several "Planned" Dates falling on these non-working days based on planned durations, instead of pushing these out to the next working day (This also happens for Saturdays and Sundays while we have defined M-F…
- Combined Update request across multiple projects/sheets
Hi, My teams work concurrently across multiple projects. Is there a way to combine status update requests for tasks across multiple sheets so that they receive a consolidated update request for all projects? I have created a "Current User Report" which shows tasks across all projects for each user, but am having difficulty…
- Networkdays Error - Dates used in cross sheet references
I get an #INVALID DATA TYPE error for this formula: =NETWORKDAYS([Baseline Finish]@row, [Planned Finish]@row). The Baseline Finish and Planned Finish date columns pull these dates from a different sheet using cross-sheet links. Any suggestions?
- Can Smartsheet automatically update "Planned" dates based on "Actual" dates?
We use "Baseline", "Planned" and "Actual" Start & Finish columns on our projects. Is there a way to automatically update "Planned" dates for successor activities based on the "Actual" dates for predecessor activities? e.g. If a predecessor's "Actual Finish" occurs 2 days earlier than its "Planned Finish", can Smartsheet…
- Status Update Requests - When predecessor tasks have not yet been completed
We have set up daily status update requests for our projects for task owners 1 day before "Planned Finish" date. We run into an issue when one or more "Predecessors" have not yet been completed. The automation pings users for successor tasks, that they can not start/finish, as they are waiting for the predecessor task to…
- Nested ISDATE error
Hi - I am trying to count the NETWORKDAYS between [Date Assigned] and [Date Complete] if [Date Complete] is a date, otherwise to calculate NETWORKDAYS between [Date Assigned] and TODAY() using this formula but get an argument error. Looking for help! =IF(ISDATE([Date Complete]@row, NETWORKDAYS([Date Assigned]@row, [Date…
- Why does =TODAY() - Created@row give inconsistent results?
我有一个汽车号码column [Created] that captures the time a row is created. In another column [AGE], I am trying to calculate the age by using the formula =TODAY() - Created@row. For some of the rows created today, this formula gives an AGE of 0 days, but for others it results in -1. What am i doing wrong?
