-
Starting a task based off of a column selection
Sorry if this is covered elsewhere and if it is can someone send me a link? Basically we are setting a sheet and are hoping to auto add a child row based off a column selection. Ideally we could choose what if any to prefill in it but even just being able to get a child row to auto add would be a huge help.
-
Duration is not calculating correctly when using hours duration
Some parent rows have 0 days as the summationof the assocaited child rows and and some have arbitrary number of days. Since it is in a rollup value from child rows I cannot change. Any suggestions?
-
Modeling uncertainty: "Expected Value" for staff allocations on future potential projects?
My company is a consulting firm that must manage an uncertain project flow. We use one Smartsheet per project, creating a new project smartsheet whenever we submit a project proposal. However, there is always uncertainty as to whether we will actually get any particular project. We definitely don't have a 100% success…
-
How to count quantity of date entries within a month time frame?
Hello All - I have 10 years of data that I would like to produce historical infomration, and eventually trailing charts. I want to produce a chart that will tell me how many leads we received on a per month, per year basis. I have shared a screen shot, and example of what I am trying to do. I keep getting a "zero" for a…
-
Trying to validate date fields in some way.
Hi I have created a sheet so that our Admin team here can accurately record sales information and can then run reports to calculate commission figures. I can share this sheet if anyone would like to see it. I am using a lot of conditional formatting to avoid input errors so that the output reports are accurate and correct.…
-
Exclude values based on formatting
i.e. exclude red from a SUM function, so all the red values are not added up
-
SmartSheet Function Similar to Excel MOD Function?
Is there a SmartSheet function similar to Excel's MOD function. I need to create an IF statement based on if a quotient is a whole number/integer or has a decimal (has a remainder after division).
-
How to use a range of numbers in a formula
Hi SmartUsers, I have a formula to show bars according to the completion % of a cell. The formula is: =IF(Completed?9 = 1, "Full", IF([% Complete]9 = 0.25, "Quarter", IF([% Complete]9 = 0.5, "Half", IF([% Complete]9 = 0.75, "Three Quarter", IF([% Complete]9 = 1, "Full", "Empty"))))) It'll show 1 bar if a task is 25%, 2…
-
Conditional Formating between 2 dates
I know how to achieve this in excel but can't figure it out here. We are looking to highlight a cell (or row) if the number of business days between two cells is less than 3 business days For example in a row we have: Date1 = 11/30/15 Date2 = 12/2/15 In this case above we would want to color Date2 red (or the whole row)…
-
"Forms" Can I use a drop down field to direct the form information to a specific email address?
I am looking to use a drop down in the form to direct the form details to a specific email address. For example: If i choose a specific country from the drop down the details of the form would be directed to an email that i configure. If is select a different country it would go to a different email address. Thanks!