-
Sheet to Sheet with Parent Rows
I have created a sheet that when a check box is marked it moves the entire row to another sheet. I was wondering if there is a way that when the row moves to another sheet if I can have it populate the information under a parent row? Example my Scheduling sheet moves the row to my Machine sheet. My scheduling sheet I make…
-
Formula to update status on a parent row based on child row with OR statement
Hi - I need a formula to update the status on the parent row based on status values in the child rows below. I am wresting with this formula and hoping someone on here can point me in the right direction. I found this post which is exactly what I'm looking for but there was never an answer to her last comment about needing…
-
formula handbook for EU region
could you give access to the formula handbook to all regions? Thanks
-
Need help with a VLOOKUP formula
Hi all, Just to be upfront, formulas are my Achilles heel, so I'm not sure if I'm doing this right. My company has a Lucidchart training coming up, and we've created a sheet/form that will list out everybody who has filled out the form and has expressed interest in the training. I've also imported another sheet that lists…
-
Looking for solution to "Parent vs Ancestors" problem
Hello, I have been having tons of trouble coming up with a formula that will give me the desired result. The goal, it to populate a column with two pieces of information from other columns. In the attached image, the column "project name and header" is supposed to take the ancestor of SLS Job Number and the ancestor of…
-
Standardising imported date formats
Hi, I hope you are all well, and someone may be able to assist: On a sheet I am working on, a 3rd party app runs an automation that imports a date into a specified column in smartsheet. The date when imported arrives in the following format: "2023-01-04 12:26:14". There is no way to change the format which this date is…
-
Is there a formula to calculate years, months, and days between 2 different dates?
I found a formula that calculates the years and months between 2 different dates, but because it's not also calculating the days, it is rounding up the months which isn't going to work in the case that I need it. Here is a picture of what I'm looking for (how many years, months, and days) Purchase Date to Expiration Date.…
-
Index Match Else
Greeting All, I have created a simple index match that successfully matches state/province from my reference datasheet to pull in the corresponding district. I would love to indicate "N/A" for the instances when a state is blank but I cannot figure out the argument. =INDEX({District}, MATCH([State/Prov]@row, {Reference…
-
If And Formula for between dates
I'm trying to write a formula to return a "1" if the reference date falls between two dates. The highlighted Q1 should show a result of "1" based on the criteria further down the sheet as shown below. =IF(AND([Planned Date]@row >= $[Actual SIP Date]$177, [Planned Date]@row <= $[shipped On time]$177), "1", "") returns a…
-
#UNPARSEABLE error
Hi everyone. New to smartsheets and im having issues with my formula. Works fine on google sheets but dont know how to get it working on smartsheet. Please see an example:…