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…
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…
Good morning Experts, I have a particular set of data that is tracking productivity with a time element reported as (hour):(minutes) AM or PM I am gathering the data in a form using text/number. Once in the sheet/grid I cannot figure out If I can or how to auto populate the results for a single time element in my sheet…
Hi, Is there a way to add like a string "[Column Name]" so whenever I add a new column that has that name the formula stays refrenced to that new column with the same name? Thank you!
Hi everyone, I currently have a data set for which I would like to count all unique values that are under a same month and a same year. For example, the following table shows two duplicate values (TR ID's) on two different dates. In this case I would only like to count the unique TR ID's for the month of August, 2020…