I have created a workflow that seems simple enough. I am using it to approve document changes.

The trigger block is the date change (Revision date).

The "Other" is if the Supervisor Dept has not been selected, it would Request an Update from specific personnel.

However, I made some updates to a

I have a metrics sheet built out referencing a master sheet. The master sheet is a running tracker and each month we add new rows to it. Any time we do this, it shifts my reference ranges on my metrics sheet. We've tried adding new rows to the very bottom of the master sheet as well as inserting the

An employee retired without transferring his sheets and reports, that are in various workspaces and folders, to me. How do I keep the sheets and reports in the same workspace and folders while transferring ownership to me? I'm SysAdm and licensed user on Enterprise

Formula gods, looking for help, please.

I'm trying to write a formula that says if the finish date is not blank, then the QA status is Green, if finish date is blank, then go to the days open field and if less than >= 60 and <=89 then Yellow, if days open is >=90 then Red.

I can write the individual

I am trying to calculate a variance by subtracting two columns but only if one of them is not blank.  I'm having trouble getting the ISBLANK condition to work.

My current formula is  =[Budgeted Total]4 - [Amount Spent]4 but I only want to apply that formula if Amount Spent is not blank.

Any

Hi there,

We have just started using a simple workflow to approve capital investment projects in the business. The workflow submits each project justification through a hierarchy of approvers, dependant on the value of the project. The workflow has minimum of 7 approvers in the process for a given

Is there any way to select only specific columns to be included in alert messages that are sent out using the SmartSheet Automation feature?

Currently, I set up an alert. And it displays all of the columns, even if I hide certain columns in the sheet. I'd like to be able to select which columns are

I am working on a 6 months rolling metrics calculation for a point system.

A simple data involved will be as follows:

1) Date column

2) Points column (0-10)

3) Name column

I need to calculate a 6 months rolling sum of points, for each person.

I couldn't figure out how to calculate the sum of

I am trying to average a customer feedback section of my sheet.  But if the cells where the data to be averaged will come from, the result section shows #Divide by Zero.  I use the formula =AVG([column1:column2]).  What's the formula I need to use for this?  I saw in the other community discussion

Hi All,

I am trying to write a COLLECT which excludes results based on the value of a cell, similar to how NOT(ISBLANK(@cell)) works.

Below is a formula I have made which works, but I was hoping there was a more succinct way to achieve the same result 

=JOIN(IF([Audio Language]153 <> "English",