-
COUNTIF Formula Returns Zero in Sheet Summary
I have a very simple COUNTIF formula that isn't working in the sheet summary section. For example, I'm trying to count how many times the year "2017" appears in a column called "Tablet Year". The formula should be: =COUNTIF([Tablet Year]:[Tablet Year], 2017) I've also tried surrounding the "2017" in quotation marks in case…
-
Merged: Duplicate/repeat column settings
This discussion has been merged.
-
Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…
-
Control Center & Multi-select dropdown
Hello. I'm looking for some feedback on a control center process we've built. We have an intake sheet with standard and optional department assets depending on intake data. To mark which assets we need to create, we have multiple columns with multi-select dropdowns for each asset by department name. What my goal was to…
-
How to adjust Gmail Add on?
I have installed Smartsheet add on for Gmail and I would like to know how to set it up to show only certain columns for one of the sheets based on the access or on how to set it up as currently it shows all the columns when you select a sheet. Screen shots attached.
-
INDEX / MATCH and HAS / CONTAINS?
I'm determining how long a person has been parked based on the parking lot zone number and the amount of money paid. I have a separate reference sheet that lays out the zone numbers, location names, and all of the possible amounts someone could have paid in this lot - this is the sheet I'm trying to reference. When I…
-
Merged: Time Column
This discussion has been merged.
-
TIP: Calculations on an AutoNumber Column
I've noticed when trying to run formulas on my AutoNumber column, that it doesn't always work. Here's a table of some of the results. For each row I changed the autonumber "Numerical Places" from 0 to 00 to 000 to 0000. You'll see that the results conclude that Formulas on an Auto Number column MUST USE SINGLE DIGIT…
-
Does reordering columns impact any other existing logic? The column title would remain unchanged
Does reordering columns impact any other existing logic (datamesh, formula, workflow, helper columns)? The column title would remain unchanged. Specifically, is there any reason this could impact a helper column using a formula that references the column being reordered?
-
Ability to Customize Displayed Columns on Initial View of Selected Workspace(s)
Currently, after selecting a Workspace from the Browse panel the initial screen displayed has six columns displayed: Select (checkbox; ☑️) Favorite (star; ⭐️) Name Sharing Owner Last Update It would be great to be able to customize these columns with additional data points to aid with navigation and understandability (from…