tfassnacht’s Profile

Community member since March 2019

points
132

2

Hello Community,

 

Excel has this "Trace Dependents" function which enables to know if (and where) a cell is refered in another cell formula.

 

I can see that when a cell is further used in a smartsheet formula, the cell has tiny black/blue arrow.

 

But I struggle to know the cell dependance.

 

Any

6

Hi community,

I have a smartsheetA and smartsheetB. They have the same column client and should contain the same drop-down values.

 

For each smartsheet I have to manually input those values in drop-down values possibilities. I risk to create a typo and then formulas don't work.

 

Is there a way I

9

Hello community,

 

I have a smartsheet with 5000+ rows.

I would like to find a way to automatically Go To line 2000 (and not scrolling down).

Is there some "GoTo" hyperlink I can create ?

How shall I do this ?

 

Best,

1

Hello community,

I have a sheet called Boundary.

ColumnA is called "Distance" and has integers .

ColumnB is called "distance_to_increment" and has either an integer or a blank field.

 

From another sheet called Summry, I would like to sum, all distances which have a blank field for column B.

 

I