-
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…
-
Add a Formula to a Cell Using Automations
Is it possible to add a formula to a cell using an automation? I attempted to do this using the Change cell value action, but it only adds the formula as text. The sheet does not recognize it as a formula even though I did start it with an "=". I'm trying to populate the value of a cell with data from a cell in the same…
-
IF and Conditional Formatting
I have some conditional formatting set up so the field crew can make the needed measurements. I have a formula in the Delta column that adds up the measurements and subtracts that from the Qty for each column. I have an Automation that sends an email out if the Delta is above a certain threshold. I don't want the Delta…
-
Auto Generate sequential # to different Project ID category
Hi there, I am looking for a formula or a solution to auto generate Project ID with sequential # once Project Type was chosen in Intake Form. I described what I would like to achieve in detail in an attached document. Could you kindly take a look at it and let me know if this is something SmartSheet can handle? Best…