-
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…
-
Trying to use sumif with dates
I am trying to sum values from Study column which only have a value in start date column less than today's date. =SUMIF([start date]1:[start date]9, "<"&today, [Study]1:[Study]9) the result is #UNPARSEABLE and I don't know why. Does anybody have advice? ex: start date Study sum 11/1/17 12 11/1/18 3 12
-
In excel you can have multiple worksheets in one document. How does this work in smartsheet?
In excel you can set up multiple tabs or worksheets in one document. How can I best do this using smartsheet? Any tips? I have a excel sheet from finance using multiple worksheets and staff names, project codes and formulas for high level tracking of time against multiple strands of work. I would like them to use…
