-
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…
-
What Formula to use to Count the number of Unique Dropdown Phrase Utilized
I'm new to Smartsheets and I've been tasked with going over the SWOT data. They are asking me to go over each category of SWOT with the unique data point they captured and tallying how many times that data point is utilized. The Data Point Column is a dropdown list. For example, I am having a hard time counting how many…
-
COUNTIFS Formula to calculate the number of values in a column with multiple values and parent rows
Hello, I'm trying to help a colleague set up a metrics sheet that can help them report on the number of skills they have within their department. There's a sheet of all the people in the department, which has a record of the person, their skills and what they are booked to work on. • Each of the people records are assigned…
-
Drag & Drop Emails from Outlook to Smartsheet in Chrome & Email is Deleted from Outlook
When dragging the email from my Outlook window to Smartsheet in Google Chrome it removes the file from my Outlook entirely and the email is gone. I tested this in MS Edge and confirmed it does not happen when using Edge; the file copies and uploads to Smartsheet without deleting it from Outlook. * Windows 10 Pro for…
-
Help! Multiselect Column Formula with INDEX, MATCH and HAS
Hello Smartsheet World! I am attempting to run a formula that will return contact emails depending on which departments are selected in a multi-select dropdown column. Sheet 1: Improvement Notes Smartsheet -Dept Attention column is a multi-select dropdown -Department Contacts column (in green) is a contact list that allows…
-
Wrike/smartsheet Integration?
One of our departments made a decision to get Wrike last year. They've told me it can integrate with smartsheet- but I haven't found anything that explicitly gives how-to kind of guidance or is it just an API kind of thing where we have to pretty much develop it. I hope to show the team all the great new functionality we…
-
reoccurring weekly task with auto updated due date
Hi, I'd like to set up a reoccurring weekly task. When completed, it would reset the row status from "done" to "ready to work". The due date would auto-advance by one week when the status is reset to "ready to work" NICE TO HAVE: I know from the get- go that some months this task won't occur at all. Can I schedule the task…
-
Timestamping
Hello. Is there currently anyway to do timestamping in Smartsheets? For instance, timestamping a cell when a tick box cell is ticked? Thanks Andrew
-
Translation of text in sheets
Hello everyone, I would like to create a sheet that will be mainly consisting of text database and I need these to be translated into many languages so everyone across our company can understand it + customers, people in the production (who are not familiar with english) etc. Is there a way to translate text in sheets? I…
-
Formula: CountIf
Here's the situation: I have seperate source sheets for each function (Human Resources, IT, Finance, etc.) that syncs with data mesh (copy data) to a master sheet. However, sometimes rows get deleted from the source function sheets and then our master sheet still has the deleted row on it. I'm trying to have a checkbox…
