-
How do I create a formula that will subtract a percentage from another cell
If cell B2 in column titled "Total Cost" is $25,000.00, and I need to subtract 6.35%, what formula would help me do this?
-
How do I create a formula to SUM the Child column only if a tickbox in a separate column is ticked
Hi I need help with creating a formula to calculate the numerical values in the child coulmn but only if a tickbox is ticked. So far i have come up with ="Total Withdrawn: £" + SUMIF(CHILDREN(Completed2:Completed4)) Any help would be appreciated. Jordan
-
How do you SUM a Child row with the condition that a separate colunm check box is ticked
Hi I want my spreadsheet to SUM the child numerical value under the condition that the tickbox in a separate column is ticked, so far I have come up with the formula ="Total Withdrawn: " + SUMIF(Completed:Completed , CHILDREN()) but it doesnt seem to work. Some help plese.
-
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).
