-
Finding a Smartsheet Contractor
I'm looking for information on how to find Smartsheet contractors to set up a complex project with dashboards and reporting as well as train our team, document the process, etc. Is there an existing discussion on this topic? I'm looking for any available guidance that anyone may have to offer. Thanks!
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Is there a formula to get the average of star ratings?
I have a column that is only star ratings. I am trying to the get the average rating of the entire column in a sheet summary field. I tried to just do the average formula for the column and got the #DIVIDE BY ZERO error. Is there a formula that can calculate the average without having to create a helper column to translate…
-
Automated Workflows Limit
Hi Is there any limit to how many "automated workflows" we can create in a single sheet? Asking because one of my projects is expected to have approx 30 automated workflows in it.
-
Certified Smartsheet user on the look out
Hey friends, Anyone hiring experienced Smartsheet user, if so let me know! 😁 I've been using Smartsheet for 6 years, it's so much a part of my daily work productivity and I'd like to seek out another opportunity where I could transition my skills and background in program management into. I've gain so much knowledge and…
-
Software solution using Smartsheet
Hello, My experience thus far with Smartsheet has been as a Systems Administrator for the last four years. Prior to my even learning Smartsheet, I had this idea for an app that would help to streamline a very specific business practice within the higher education industry. The thinking was that I needed to have someone…
-
Smartsheet University Is Here!
Hi Community, We are excited to introduce Smartsheet University, a single platform for eLearning, live instructor-led training, in-person training, and custom training. Smartsheet University offers unique learning paths and meaningful content that focuses on the knowledge and skills that matter to you, your industry, and…
-
IF Cell Contains This Text VLOOKUP
Hello, The Status Column has a dropdown menu with multiple options with the text "Completed" and some other options: Completed awaiting Signature Completed Reviewing Completed Approved Failed Inspection I want this formula to work with any options from the drop-down menu with the letter completed. This is what I have so…
-
Is there a function that counts a cell if it contains a value rather than equals that value?
Is there a function that counts a cell if it contains a value rather than equals that value if you have cells with "dog", "cat", "cat dog" and you want to count "dog" using excel you can use this formula =COUNTIF(A1:A3,"*dog*") but the * doesn't seem to work in smartsheet
-
Expandable/Collapsible Columns with buttons (not hiding)?
Is there any capability in Smartsheets similar to this excel screenshot where columns are able to be expanded and collapsed in a grouping using a button? The scenario at hand is supplier contact information being tacked on in several columns at the end of a sheet and it isn't information used on a regular basis but needs…