Best Of
Re: Basic functionality improvements
Thanks for voting, @Stevey C!
Product Ideas submitted using the Community ideation & vote system are reviewed on a monthly basis by the Product team. They look at the top-voted posts for each month and provide a Status update to indicate if it's on our current roadmap or not.
The Community is only one of the many listening channels that Product uses to determine roadmap items: we receive feedback in the application (the bullhorn icon), the EAP program, the feedback form, direct feedback, and more. This means that the votes in Community are not always representative of the bigger picture - a Community request with what seems to be a high number of votes does not guarantee that feature will be on the roadmap, but it does guarantee that the Product team will have extra visibility into the need for that item.
If an Idea is important to you, keep sharing it with others to get their votes and direct feedback as well.
Thanks!
Genevieve
Genevieve P.
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
Re: Multiple Line Entries with one Form Submission
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å
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
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
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
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
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
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
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
DKazatsky2