-
How to multiply ???
Hi, I am new to smartsheet and I have a rather basic question. I am working on a sales pipeline and I want to have an estimated sales based on the probability. The way I am setting this up is: 1st Column: Product Price 2nd Column: Customer Stage (Lead, Contacted, Negotiating, etc...) 3rd Column: Probability ( Calculating…
-
Calculate buffer for a task/chain before it affects the project completion date?
Trying to calculate the buffer a task or chain of tasks has before it affects the project completion date. iscritical allows me to determine if on critical path, in which case its 0 days buffer. I'm trying to leverage successors function to see if i can determine the buffer, but no matter what i try it just gives me the…
-
Cross Sheet Formulas within blueprint - Control Center
I am trying to leverage index/match across various sheets within my blueprint. This is faster/easier to maintain, but after creating a project or two the references still point back to my blueprint and not the new versions of the projects. do cross sheet references not update dynamically to the new projects? or are they…
-
SUMSIF if a cell has a date (or checked symbol)
I have a cell where I want to show the total but only from cells that contains a date. How can I do that? I also have a similar sheet but instead of a date, I have a checked symbol. How can I show the total just from the cells that are checked? Thanks!
-
End Date from Start Date IF Statement
Trying to populate an end date from a manually inputted start date. The end date is 9 months after the start date. Currently using an IF statement. Open to suggestions. If the month is April - December, the cycle ends in the next year, and will begin 3 months prior to the listed month.
-
Index and Match Used in Branching Formulas
I have a column using an index and match formula to index the cost based on a match of client name. In the same sheet, I have a Total Sample Cost column that sums the Normal Sample Cost with a couple of other fee columns. I did not build the sheet originally and when I went to change the pricing structure to index and…
-
Dates of Parent
so I am looking to make something and I cant seem to find what I need. I would like to use EXAMPLE Parent Date | =last date entered below or keep blank tell all Childs are filled in Child Date 1 | 1/1/22 Child Date 2 | 12/25/21 Child Date 3 | 11/9/21 Child Date 4 | Blank i know =MAX(CHILDREN()) will kind of work but it…
-
Trying to sumif after current date
Hi, i'm new at smartsheets and i've been trying to create a formula to sum a money column after the due date for it's payment has passed. I've been reading this article and trying to adapt it but failed completely. I've tried to used a Today formula to replace the Year in the example but couldn't get the formula to work.…
-
Rolling 12-months formula: % of projects completed on time
I am looking for a formula that will calculate the % of projects completed on time when the actual complete date is on or before the scheduled complete over a rolling 12-month period and the Project Status is Completed. The rolling 12-months will be based on the Actual Complete Date column. Below is is the data. So for the…
-
Is there a work around for trying to use CONTAINS() or HAS() within collect()?
I am trying to summarize my projects data that is assigned to a work type, dates/weeks specifically and then count it by week or singe day. Can't figure it out. I have a summary sheet that brings in a multi select column (I have also tried it just text) off all the dates each work type has work. I am then on a separate…