Community

We're pretty excited to start our Smartsheet journey; the functionality looks amazing!

I'm struggling to wrap my head around how to make different sheets related to each other.

Let me give you an example of what I want to achieve, and perhaps someone can point me in the right direction.

Imagine

I am trying to set up a formula that counts the number of cells containing information in the first column on another sheet. I just don't want it to count the text that is in row 1 (ie I just want it to count from row 2 onwards as I am constantly adding data to column). I don't want the formula to

I am working on a budget tracking sheet where I have a forecast column.  The forecast column is dependent on if there is a value in an estimated cost column or actual cost column. 

If there is no value in the actual cost column, then the forecast column is equal to the value in the estimated cost

Hi Folks,

I have the following formula used to track specific assets:

=SUMIF({EventDate_req}, $DateNeeded$1, {Asset2_Range})

This adds up the count in  each row in the Asset2_Range that matches the date needed.

We created individual one column ranges for each asset (Asset1, Asset2, Asset3) etc.

In Sheet 1, I want to COUNT instances of value across a range of cells in Sheet 2, with some cells containing multiple values, separated by commas.

Let's say Sheet 2, has the following values in a range of rows:

SHEET 2

1: |   blue               |   Group 1

2: |   blue, red        |   Group 2

3: |

I am creating a per week rollup that shows a sum of the children rows from another sheet. It looks to me like SUMIFS does not work if the range referenced contains a formula. Is this a bug, limitation, or do i have an error in my formula?

=SUMIFS({ManpowerPerTaskApp}, {ManpowerWorkingStart},

I have created automation for my IT Request form where the User Name [Any Value] is the Trigger. So, depending which "Requester's Title" is chosen from the 2 dropdown options in my form; Supervisor, Manager, I need to set one Request for Approval path if Manager is selected, and a second Request for

I can't trust taskees to update [Actual Finish] reliably, so automation seems to be the key.

I want to automate [Actual Finish] based on when [% Complete] reaches 100%

I have really tried to bang my head through this, but to no avail. I keep running into endless updates of [Actual Finish] or

I am trying to find the min value of CHILDREN in a column of numbers where the value of the [% Complete] cell in the row of that column is not = 100%, but, again, only for the CHILDREN. 

Using

=MIN(COLLECT(CHILDREN(), [% Complete]:[% Complete], @cell < 1))

or

=MIN(COLLECT(CHILDREN([Days Till

Hi Community...having issues with this formula working for the "Gray"Status.  The other criteria is working so can't figure out why I can't get gray status to work.

=IF([Actual Progress]10 >= ($[Week 1 Target Progress (Aug 22)]10 * 0.8), "Green", IF(AND([Actual Progress]10 < ($[Week 1 Target