-
Conditional Formatting
Is there a way to add a conditional format to a cell that has a drop down RYG...like project health? If a task date is past due, I want the health cell to change from green to yellow automatically. Thanks for any help!
-
Counting "At Risk" Flags
Hi, I am trying to use COUNTIF for counting number of projects with "At Risk" flags turned on. I get #UNPARSEABLE for this- COUNTIF(At Risk:At Risk, 1). Any feedback appreciated. Thank you.
-
Formula Predecessor Help 2...
I could use some help. I've implemented J. Craig Williams' predecessor solution allowing notifications based on the predecessor being complete for a given task: 1. Create a column to get your Row# [RowID] In the first row, put a 1. The second row, use the formula =RowID1 +1 and copy that to all the other rows. 2. Create a…
-
Days Since (Single Date)
I have to do some invoicing and want to know how many days since an invoice was issued. I can sort out how to find the days between two dates but I only have one date to work with here. Would love if someone could help!
-
Harvey Balls / Lookup or Max ?
Dear all, I am trying to find a smart way to use formulas to make a large data table more accessible. The situation is as follows: I have a number of companies that are represented by one line in smartsheet. This line included a unique ID as well as names, etc. For each companies I can have 1 or more lines - children -…
-
Counting formula to see how many status each person has
So I want to see how many Not Started, In-Progress or Completed each person has.
-
Formula
Hi, Hopefully I'll explain my predicament correctly! Ive set up a sheet for the commercial department to track orders. I need a formula to track the value of orders quoted in a certain month. The column I need the date range to come from is called Date Out The column I need the descriptor to come from is called Status, and…
-
Auto-populating a sheet with filtered data from another
All, I'm hoping someone can suggest a solution. I am trying to reduce the amount of time spent re-entering data about upcoming bids from one spreadsheet to another. My company has a master list of bids over the fiscal year and every week my boss produces a separate sheet of just the upcoming bids that he can then use…
-
PERT: +/-2 sigma (Probability 95.46%)
Good Day All: How do I take the following excel formula and use it smartsheet to get the same results Excel formula =$G$30-2*SQRT($I$30) Results: 1.33 Smartsheet Formula =$Expected$26-2*SQRT($Variance$26) Results: UNPARSEABLE I tried using ^2 for square root but still receive the same results. Thanks
-
Creating Web forms with Auto-populated form content
I see that you can auto populate a section of the form by manually entering (post-URL): &ColumnName=text where any spaces in the text are replaces with %20. Question: I first used the substitute function to replace %20 for all spaces in a column that contains the desired text. But am unable to have the sheet pull that…