Best Of
Re: Add a formula column to multiple sheets efficiently
In that case you MIGHT be able to use the API. Otherwise you are looking at a manual process.
Paul Newcome
Re: Add a formula column to multiple sheets efficiently
I hope you're well and safe!
The premium app Control Center would be the best solution, but all sheets would have needed to have already been provisioned.
What I'd recommend is setting up the formulas in one sheet and then adding a special character before it so it's not active and then creating a report and copying/pasting it and then user Find/Replace on the special character so the formulas activate, but you'd unfortunately would have to right-click and activate the column formulas manually, or maybe use the Smartsheet API instead or a macro engine.
Make sense?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
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 Question
Hey @Kris Peeters,
Can you add a snapshot of your automation?
My guess is that you didnt set a condition for which rows it should send.
When you set an automation to send when row changes, you also need to set a condition under it so it will only sent rows that are within this condition.
Hope that helps.
Itai Perez
Re: How to include default values for new tasks in a Task List?
Hi @BESSjd,
A couple of ideas for you on this one:
- If you want to have selectable contacts in a dropdown via a form, pre-populate 'Add contacts' box when setting up the column. These will then be available for people submitting the form to select from.
- For any formula-based defaults, if you add a helper column as an override, you can adjust your formula to pick up the override if it is populated, or go with the default if not. Something along the lines of: =IF(Override@row<>"",Override@row,"Default value").
Philip Robbins
Re: PDF to MYOB
Hi @Julieh
@Ipshita is referencing MYOB as if it's a specific User, however I believe this is a secondary software that you're looking to integrate with Smartsheet, is that correct?
Without knowing too much about MYOB, I believe you may be correct in saying you'll need to download the file to then send it in the correct format.
See: View and download attachments
Cheers,
Genevieve
Genevieve P.
Re: URL for a row of data
HI @alexis.ray89371 ,
Right click on the left hand side of the row (in the row number), then Properties. A small window will open with the Row Link as the last option. You can also click any cell in the row, row actions and then properties for the same result.
Hope this helps!
Nick Korna
Re: Introducing the 2023 Core Product Certification Exam + Community Badges
Hi @Arsineh I passed my core product certification exam on July 28. The badge is in Credly but it is not showing in my profile yet. Do you know when I can expect to see it? Thank you
Greg_Lea
Re: Count if all, cells contain a specific word.
You'd change the formula to COUNTIFS and add in the extra column(s) & criteria. That the other column's value is calculated rather than directly input shouldn't matter.
If you're looking for a single text value, then you can just use "text" as the criteria, or use CONTAINS in a similar way.
Nick Korna
Re: Customize the From Name of Smartsheet Alerts and Requests
This isn't really what we asked for. We want to be able to customize the sender name/email. We would like for the notifications to be sent from, and responses to go to, a specific email address. This is often a shared email box that can be accessed by multiple people, rather than sending tons of emails directly to an individual (who may or may not have anything to do with it, they only created the sheet).
This is definitely a step in the right direction but seems like a halfway fix being wrapped up as the solution we wanted, but it isn't.
AmandaWebb
Re: If statement referencing another sheet returns invalid operation
@pdv90 Your formula isn't working because you are comparing an array to a single cell. You can try the following
=IF(CONTAINS([Cutting Room Number]@row, {Master Bookings Sheet-V2.0 Range 1}), "Unavailable", "Available")
Eric Law