Best Of

Re: November Question of the Month 💭 Join the conversation and receive a badge

Just one? Oh... decisions, decisions.... 😀

Datashuttle - HUGE time savings getting data into my sheets.

DataMesh - one of those "Why do I need it?" that turned into "How did I live without it??" features

Formula Help - makes formulas easy with the syntax and prompts right on the screen

And yes, I can't ignore Dashboards.... because those started my Smartsheet obsession 😃

MCorbin

3 ·

Re: Multiple Line Entries with one Form Submission

Hi @Carrie Barnett

I hope you're well and safe!

I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.

Would that help/work?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

1 ·

Re: Automation copy row into the same file

I will answer myself in order that anyone who see this knows what happened. In the main sheet I have a column with column property "# Auto number", then I am assuming that the automation cannot take that information and translate to other sheet than the column property is other. Since the moment that I change the property column to text, the automated flow starts to work again.

Raul Cabrera

1 ·

Re: Create a Count of how many Not-Completed items to use in Dashboard

Hey Vince,

Looks like a cross sheet formula? try =COUNTIFS({Name of sheet 1}, =0).

When you type in the cell =countifs( Smartsheet will open a info box, and highlight (range1, and a link Reference Another Sheet. Click this, find your sheet and select your Completed column, this is your range 1. In my case the formula looks like =COUNTIFS({Construction Schedule Range 1}, =0)

Hope this help, not sure how well versed you are in Sheets. Any more than this and I could be getting out of my knowledge base.

Jason P

1 ·

Re: Can I create a Column Formula which automatically applies text in a Parent Row to the Child Rows?

Hi Dayle

Is this what you are looking to do?

If so, the Formula in the col Parent Info would be:

=PARENT([Info from Parent]@row)

I hope that helps. If it's not what you are looking for, please let me know.

Kevin Smith

1 ·

Can I create a Column Formula which automatically applies text in a Parent Row to the Child Rows?

When rows move into my sheet, I use them as parent rows for my projects. I want to have a column formula which automatically pulls in data from the parent row to its child rows. I've tried putting =PARENT() into a child row but it makes all cells in that column empty when I convert it to a Column Formula.

Any assistance would be hugely appreciated - I'm new to Smartsheet forumlas, I've been using Automation as a workaround but this has limitations.

Dayle_Taylor

1 ·

Re: How can I get the copy of "Send me a copy of my responses"

Thank you. We recieve over 400 requests a week, it is not scalable to create a document for each scenario. I need an automated way to get the same information that is sent to the submitter to specific teams based on the selections made. I have work flows for this - The teams get the information but the formatting is terrible and it links to a sheet they don't have access to (they only need to know what the submitter filled out in the form). The copy of response sent to the submitter is exactly what I need sent out to my different teams.

CarlyDowning2

1 ·

Re: Average symbols for growing number of columns

You would first need to convert the bars into numbers. The easiest way to do this would be to add a series of COUNTIFS together.

=COUNTIFS([Helper 1]@row:[Helper 2]@row, @cell = "Quarter") + (COUNTIFS([Helper 1]@row:[Helper 2]@row, @cell = "Half") * 2) + ......................................

Then you would take that and divide it by the number of cells that aren't blank.

=(COUNTIFS(.....) + (COUNTIFS(.....) * 2) + .....) / COUNTIFS([Helper 1]@row:[Helper 2]@row, @cell <> "")

I would suggest leaving this in its own column because from here we need to use a nested IF. Dropping this into a nested IF will provide for a single column formula, but it will be rather large and unwieldy. Putting the next piece in its own column will make things much easier to manage and troubleshoot.

=IF(Formula@row>= 4, "Full", IF(Formula@row>= 3, "Three Quarter", IF(..............

Paul Newcome

1 ·

Re: SUMIFS Formula with Three Conditions

Hi @twallen,

Just add a

HAS() to your formula and you will be all set - this is needed for the multi-select field.

=SUMIFS([Total CE Units]:[Total CE Units], Employee:Employee, "MB", [Applicable Categories]:[Applicable Categories], HAS(@cell, "HSW"))

Later, to add the year part, use this.

=SUMIFS([Total CE Units]:[Total CE Units], Employee:Employee, "MB", [Applicable Categories]:[Applicable Categories], HAS(@cell, "HSW"), [Date Earned]:[Date Earned], @cell <> "", [Date Earned]:[Date Earned], YEAR(@twallen

Hope this helps,

Dave