-
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…
-
Looking for formula
I'm new to using Smart Sheets and looking to calculating aging date for invoices for tracking purpose. I tried several ones I used for excel but does not seems to work here. I did also use some of the formula's people had suggested on the blogs here but no luck. Please help. What I have is the invoice date and need to know…
-
Conditional calculation?
I am trying to create a formula that will calculate sales commission based on which marketer is named in another column. I have two marketers who are at different commission levels. I would like the Commission column to automatically calculate the commission total from the dollar value in the Services column, based on…
-
Help on formula: Monthly savings calculation
Hi, Please need your help on how I can calculate my monthly savings on completed projects. I am currently using the below formula but couldn't get it right. =SUMIFS([Negotiated/Potential Savings]:[Negotiated/Potential Savings], [Actual End Date]:[Actual End Date], <=[Summary Info 3]41, Status:Status, "completed") Kind…
-
RYG Ball Formlas
I am having a hard time putting together the formula for my Health Column- RYGB Ball. I need the formula to be the following. Any chance some one could help put this formula together for me? Thanks * If Status is Not Started then Health is Blank * If Status is In Process and is equal to or past the Due Date then Health is…
