-
SmartSheets as Project Tracker-Too many manual steps. There has to be a better way
Buckle up. This one's a longread. TLDR: Skip to steps 5, 8 and 9 on this list. I've been using SmartSheets over the past month or so to replace my project management / status trackers. I like the automations (mostly) and that it seems fairly easy to use. It seems like it has some problems that I find very surprising and…
-
warnings, when a reference, cell link or formula get corrupt
Hi, I was wondering if it is possible to get warnings, when a reference, cell link or formula get corrupt?
-
Bulk Cell Linking - Columns
Hello - I am trying to perform the following actions, which would happen in this order: Person Inputs Project Information into Intake Form, which gets added to our master report. Column Examples - Project Name - Project Address - Project City / State A New Project Folder would be Created for this Project, Which Needs the…
-
Finish Date Static vs Duration Static
Can the Finish date be static and have the start date and duration dynamic? Example: I have Task 1 and Task 2. Task 1 has a duration of 5 days and Task 2 has a duration of 10 days. Task 2 has a dependency on Task 1. But Task 2 has a due date that cannot change. If Task 1 goes over the 5 days by one day, I update the…
-
Formula/Function to pull new rows/updated rows to another sheet
Hi Everyone, We have a critical issues list that is maintained by another group, and I've created an end-to-end schedule that will determine whether or not we will have the issues "validated" by our Week 0 deadline. Since the source sheet is constantly being updated and new issues are added weekly, I want my sheet to be…
-
Does anyone know how can I link cells from various projects into one sheets in order to make a gantt
Does anyone know how can I link cells from various projects into one sheets in order to make a gantt
-
Autofill based on Previous value.
Hello Team, I am preparing a service request spreadsheet. Users will be entering the issues, and the service request number should automatically pop up. upon all of the values entered. In this case, the Green highlighted values will be entered through customers via Form. Upon all of the values entered by customer,…
-
COUNTIFS between dates & criteria.
Greetings Smartsheet Community, I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame. So far I am successful counting the dates in the range using the following formula: =COUNTIFS({Range 1}, <=DATE(2018, 4, 31), {Range 1}, >=DATE(2018, 4, 1)) Next I'd like to add…
-
Searching from one sheet's range & search/match to another sheet's range for a unique identifier?
Hello, Is it possible to search from a range in one sheet and search/match it in a different range/another sheet? This has plagued me all day and therefore I can no longer remain clear headed about what the best course of action should be. I have two trackers in completely different departments; QC and PROD. I want to…
-
Formula Question - If not blank, return cell value
Would like to concatenate several cells and have that formula: =[Product Codes]@row + "-" + [Unique ID]@row + "-" + [Deliverable Code]@row Would like to add a cell only if the cell has content along with a dash preceding. Keeps coming back as unparseable. What am I doing wrong?? =[Product Codes]@row + "-" + [Unique ID]@row…
