-
Flag By Date Column 6 Weeks or Greater in the Past
Hi, We have an order intake sheet that has an "Order Date" column and a Status Column. One of the ten selectable statues is "Complete" What is the formula that I can use in a flag column to say - Flag any with an Order date 6 WEEKS OR GREATER, and Status NOT EQUAL to Complete? Thank you so much in advance! Jared
-
Email automation based on time.
We cannot set automated reminders after minutes. Our need: Send email if row has not been modified within 30 minutes of created. We also can't calculate in minutes with a formula? Just seems like a huge oversight.
-
Sum of Parent plus Children
Is there a way to get the parent row to indluce sum of parent plus children? We use a JIRA connector, and the team bills hours to the parent or Epic, as well as the Stories and Tasks with that Epic Link. As another screwball, JIRA reports time in minutes, so I have to convert Time Spent to Actual Hours by dividing by 60,…
-
Fill sheet based on another sheet (if cells contain value)
Hi Smartsheet community, I am looking for formulas or ways to automatically fill sheet B with the information of certain columns of sheet A for all rows in sheet A that contain a value. In a dynamic way, meaning if a row is added to sheet A it should be also added to sheet B. For example: - Sheet A has 1 column with 10…
-
Formula reference data exceeding 25k cells
Is there a way to increase formula reference data. The default restriction is 25k cells and i'm exceeding this
-
Auto-Lock All the Child Rows
Hi All I know how to lock a row when a certain condition (or a set thereof) is met. But is there a way that when a row gets auto-locked, all its child-rows also get locked automatically? In other words, some kind of inheritance mechanism. Thanks in advance! Nasir
-
Vlookup
I am using a this Vlookup formula =VLOOKUP([Capex APR# / Opex WBS]1, {array}, 4, false) This formula works ok and looks at data in the one sheet {array} due to the amount of data, two sheets are now required to be looked at by the formula how do I do this?
-
ISTEXT(@cell) when cross referencing a sheet
I am new to cross sheet formula's and a formula that works locally on a sheet, I am trying to cross reference so that the data that I successfully found will be on another sheet. Here is the formula that I used on the local sheet =COUNTIFS([Rep Completion Confirmation]:[Rep Completion Confirmation], "", VIN:VIN,…
-
Ghost data from unused SCC template remains
I have three different gantts with some summary data that is fed into the main project data sheet. Only one of the gantt sheets is used in a project, so I thought of linking each of the gantts' data (exact same field/cell in each sheet) to a cell in the project data sheet - then just grab the one that isn't blank or an…
-
#Boolean Expected? #Invalid Operation? I can't win for losing
I thought I was quite brilliant when I figured out that the reason a formula I created in a checkbox only column returned a #BOOLEAN EXPECTED error. I solved the problem by appending +"" to the end of my formula, and celebrated with a fun sized Snickers. Imagine my disappointment, when I tried to create a new formula that…