-
Date based formula problem
Hi there Can anyone help me with the following formula please? I've published a form which we use for collecting 'hours spent' on each project per day of week (based on a 'week commencing' field). I alreday have a report which then pulls out the time spent based on 'individual' and 'project' but I can't get the 'by week…
-
Trying to build a report, is it possible?
I'm trying to build a report from our company sales pipeline. Our pipeline has 7 sales stages. I'd like a report showing the percentage of our sales teams success progressing prospects from stage 3 or 4 to stage 5 (closed). At this point, I'm not sure how I need to approcae this report and build it. Would appreciate some…
-
Formula to calculate week number or week commencing date
I have a column of dates in a smartsheet, and wish to insert a formula into another column what will tell me either the weeknumber (e.g. Excel WEEKNUM formula) or the weekcommencing date. Does anybody have any suggestions how to acheive this?
-
Formulas Dissappear
Is there a way to keep the formulas from dissappearing? I have a formula set to check if the checkbox is checked but if the checkbox is checked independently from the main checkbox then the formula seems to dissappear. Also, is there a way to view the form as another type of user, ie...viewer, or editor? Thanks YouTube of…
-
Autofill Formula to Pre-Existing Row
On a pre-existing row of data, I want to have a formula autofill when I input new data., i.e. when an escrow closes for a client. In Excel I would simply pre-populate the column by stuffing the formula below into row 1 and then dragging down to row 2,000 then locking the column. Can I do something similar in Smartsheet?…
-
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?
