3

Dear Expert,

I have 40 sheets containing following column with example (example for one sheet only):

Equipment ID | Equipment Group | Part Name | Quantity | Unit Price | Total Price

11MBX21       | AAF                       | Bearing     |  2            |   150        |  300

11MBX22       | AAF

1

Hello all,

I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. 

I have, in one column called Terms, cells that contains lists of terms and phrases.  For example, one cell contains the following

1

Is there any updated information for linking cells between sheets with the new UI?

It looks like the direct way is still in tact (where you right-click on the destination cell, click on "Link cell from another sheet", and file through the sheets in a pane on the left until you find the source sheet,

2

I'm completely new to Smartsheet so I may be overcomplicating this, or going about it the wrong way.

I want to ensure the value entered into a field is either unique within the column, or if it has been used before, then I want to to be exactly the same as a previously entered value. 

The use case

3

I am currently struggling with the following COUNTIFS formula

=COUNTIFS(AND([Start Date]:[Start Date], <= TODAY(), ISDATE([Start Date]:[Start Date]), [% Complete]:[% Complete] <= 0.5, [Helper Column]:[Helper Column] = 3))

It should read as follows...

Count a row if it...

has a Start Date that is