-
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…
-
COUNTIFS for how many blank cells in a column, but only if another column has a populated cell
For our smartsheet we keep track of vehicles that are or are not repaired. To keep track of how many "open claims" we have I am trying to count how many blank cells we have in the column that signifies if something is complete, but when I try to just count those cells it counts the automatic additional rows on the bottom…
-
Variance Netdays
Hello everyone, I read some of the threads about this issue, but cannot find the right answer. Members of my team are consultants and work primarily on weekends so I am using the NETDAY function to calculate the variance. If I use the formula as is, meeting the deadline will give a "1" instead of 0. To avoid this I added a…
-
Formula to hold a boolean value if a row contains an attachment or not
Hi, How can I put in a formula to assign TRUE if the row has an attachment, and FALSE if the row does not have an attachment? Thanks