-
Formula vs Conditional Formatting
I was hoping conditional formatting could solve this but can we do IF/AND on conditional formatting? If not, what would the formula look like? If the End Date is in the Past AND % Complete is NOT 100% change End Date Font Red. Currently, I have a formula that will flag "At Risk" column if the date is in the past and %…
-
IF(OR Formula Help
What am I doing wrong? If Required Column, Rows 23-34 are "Yes" OR "No" THEN show "Yes" symbol, if NOT show "On Hold" This is the formula I'm using: =IF(OR(Required23 = "Yes", Required23 = “No", Required24 = "Yes", Required24 = "No", Required25 = "Yes", Required25 = "No", Required26 = "Yes", Required26 = "No", Required27 =…
-
Estimated vs Actual Time
How does everyone accurately document their Estimated Time vs Actual Time Spent on tasks for a project? Currently, in our planning process we assign a Start Date and an End Date for each task (with allocation %, duration, and predecessors for each task) once the person assigned to the task acknowledges and begins working,…
-
If then statement for Risk Management Matrix
Hi Folks - I'd like to feedback to write a formula that evaluates the following: =IF(Cell A1 "Acceptable" then??? Acceptable Tolerable Undesirable Intolerable "Then"... the statement should take the word "Acceptable" and give it a value of 1, repeating this same evaluation such that "Tolerable" receives a value of 2,…
-
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…
-
Filters and sharing as an Viewer
We have a new user with with Admin privileges to their workspace. Their workspace has a sheet and a report. Their report includes data from their sheet, which they need to be able to edit from the report, but needs to also include some data, from another sheet in a workspace that we do not wish to share with the user. They…
-
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…
-
Auto Fill Values based on existing values
In Excel, if you have a column that has say values such as "CAT", "HAT", "MAT"... If I am going down row-by-row and start typing "M" then this prompts you with the option of hitting enter or click to choose the work "MAT" as this already exists as a value in the column Does anything like this exist within SS?
-
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?
-
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,…
