-
Permit formulas in columns with the "Restrict" value toggle enabled
I have columns that are set to take certain types of data, and they contain formulas that fill the cells with values permissible within that data type. For instance, there's a field where a formula fills in one of several options based on a cell reference, or the user can manually select one of the options from a dropdown…
-
Multi-select Dropdown and multiple values
Hi community! Looking for some guidance please! :) I need a column capturing the number of specific job roles associated with project. e.g. Job Roles ---- Product Manager Delivery Manager Software Engineer Software Engineer Tester Tester I don't think this can be done via a multi-select dropdown with multiples of the same…
-
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.
-
Override Column Formula
Hi, I have a column that uses a column formula to automatically calculate a date based on other columns' criteria. However, we sometimes need to manually adjust the date and override the column formula. Is there a way to do this? Thanks!
-
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…
-
Duplicate/repeat column settings
Hi! I tried looking for this question in various ways in the community group, as it seems fairly basic. However, I'm just not finding any keywords that are leading me to the same aspect I'm trying to figure out. Currently, I'm having to create multiple columns that are exactly the same setup - or close enough. I'd love to…
-
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?
