-
Flagging Tasks as 'Blocked' if Predecessors are past due
Hi everyone! New to Smartsheet and trying to build some features for my company. I've been doing a lot of reading and tutorials, and I think I'm close to the end of this problem. Like the title says, if a task goes past its due date, I would all of its dependents tasks to flip to 'Blocked' status. I made it so far as to…
-
Revert Sheet to [Time]
Some method for reverting a sheet back to a time in the past. I created a Link Column Data sync to pull in a couple of items, not knowing it would delete all row information for the other 300+ rows. And because I was using Table view to create the link, I didn't have the opportunity to "not save" the changes to the sheet.…
-
Using a reference sheet to bring in reference dates (e.g., 6 months ago, last month, etc)
I thought it would be easiest to create a reference sheet to house dates so I'm not constantly creating timeframe stipulators in my sheets, especially now that I am trying to create portfolio level rollups. When I observe the switch over from Mar to April, it seems like in order for the reference sheet to show April 1, I…
-
Best Practice - How to introduce a new dashboard that will replace existing dashboards across multiple projects
History: Our PM's have redesigned a dashboard (status report) that replaces our current dashboard format used across all our projects. Problem: I need to figure out how to replace our current dashboard (and supporting Sheet) with minimal effort. We have a Template Library (Control Center users) so both the sheet &…
-
Tired of messy image attachments in Smartsheet?
Tired of messy image attachments in Smartsheet? I built a small tool that lets you upload images directly into **cells (not as row attachments)** — making sheets much more structured and easier to review. 🔹 Before: Multiple attachments per row → hard to track 🔹 After: Images mapped to specific columns (clean & organized)…
-
Use dependencies to set start and end dates independently
how can i use dependencies to help set both a tasks start AND end date independently (not using duration)? As an example, i would like row 3 start date to be row 2 start + 5 (I can get that by setting predecessor = 2SS+5), but I want row 3 end date to autopopulate with row 4 start date.
-
Predecessors Drop down list like MS Project
It would be a tremendous help in creating and maintain project schedules having the dropdown like in Project for selecting Predecessors it is very time consuming to have to jump out or have a second screen open to fined what needs added. This would be a huge help in schedule creation and monitoring.
-
Auto-populate parent/child rows in a separate sheet?
Hello! I was wondering if there was a way to have certain column data automatically transferred to another sheet. Once that data is transferred, I would like for that transferred data to automatically populate into an existing parent row (if the account name matches). Example: Sheet 1 is a request sheet that is auto filled…
-
Multiple Forms on single Sheet
I am wanting to have a sheet that is going to have all of our production records on it. The office manager will enter all of the work order information with 1 form, and someone in Quality will enter the measurements on another form. If I have the Primary Column as each part's serial number, will the measurement info be…
-
Merged: Elapsed days as Duration with Normal days or weeks as Lag
This discussion has been merged.