-
Sheets populated by Web Forms
I have a sheet that is populated by a web form. * The production floor inputs data into the web form. * The quality lab is "View Only" on the sheet. (on a display screen) Is it possible for the sheet to auto-refresh when new web form results have been added? The goal is - as soon as new info is added from the production…
-
Cards - Can we have support fro split columns
I was watching a video the other day on Microsoft Azure (https://azure.microsoft.com/en-us/resources/videos/242/). There they detailed the ability to have split columns under a single swimlane header. This allows you to further sub-divide the tasks within a category. Is this supported in SS? If not can it be as this would…
-
Persistent formula cells
MS Project has a lot of built in features that SmartSheet just doesn't have. Such as calculating if something is late, setting a deadline that flags if the date moves, calculating AWC and SWC, etc. To that end I have created a bunch of hidden cells that do all the needed functions and checks, and then built the…
-
IF(OR) Help needed
Hi All - I'd like to use a formula to evaluate status of red OR yellow then flag if red or yellow. I think I'm close but it's not working, please help. Here is what I have: =IF(OR([Status6] = "Red", [Status6] = "Yellow"), 1) (doesn't work) =IF((Status7 = "Red"), 1 (this works for red and sets the flag on for reporting…
-
Past Due Formula Help!!! - IF / AND
I cant seem to get the formula correct for this scenario: If "End Date" is Past Due AND "% Complete" is NOT 100% = "Complete" to turn flag red in "At Risk" column Am I correct that the formula would go in the "At Risk" column?
-
Project Presentation
I have a project presentation that will include booth visual and date, does anyone have a template i can use?
-
Display predecessor task NAME
We would like to write logic to display all predecessor task NAMES in a new column. So we want the predecessor task ID to be in its usual column, and we want a NEW column that shows the NAMES of the predecessor tasks. Anyone done anything like that? Thanks Robin
-
Date formula
Hi I'm working a construction project, and need to use a formula (or another method). To have a cell generate a remainder duartion period, based on a set completion date and duration against the current date. I look forward to any suggestions. Thanks
-
Have Sheets feed child rows automatically into a Master Sheet?
Forgive me if this topic has been covered before, I've done the best I can searching. So my employer wants to have our projects be listed in a sheet, each department in a different sheet and to have that information feed into a master sheet (or a couple master sheets actually). I know you can cell link one row at a time,…
-
Calendar vs Fiscal Year/Quarters settings
Hello, I was wondering if there's a way to update the calendar/gantt settings to use quarters based off of our fiscal year. Is that an option? Example - Q1 would be November-January Thanks, -PJ
