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…
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!
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.
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…
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…
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.…
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…
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…
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…
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…