-
How do I add conditions to an existing filter?
Hi, I have an existing filter comprised of 6 predicates which all have to be true. I want to edit this filter to add a predicate (to make 7), but I only seem to be able to remove a predicate, not add one. Can anyone help please? Thanks, GAM
-
Index/Match - Primary Sheet to Individual Sheet
Hi Community, I am looking to track training at the individual employee level as well as for my company overall to provide statistics. Currently I have two sheets. One is the primary tracker, and the second is an individual employee sheet (template). The primary tracker has approximately 107 columns, each column represents…
-
Renaming Projects in Control Center
An enhancement would be to allow for renaming projects within the control center. This is coming up a lot in current work where names can alternate and should be represented in the core of the program. My data works with properties, so keeping those names consistent as changes occur is vital to communicating the…
-
Merged: Renaming Projects in Control Center
This discussion has been merged.
-
Alpha order or Sheet Order Column List
When working with columns, such as creating a report or Dynamic View, it would be beneficial to have a choice when designing to either add all columns in alpha order or add all columns in the order they appear in the source sheet. Currently, you have to add them one by one and scroll through the alpha list to put them in…
-
LOG Function
Is it possible to calculate (or even approximate) a LOG function in Smartsheet? We regularly use the below formula to calculate A/E fees: (35/LOG(Construction Cost))-1.15)*(Complexity Factor) = A/E fee % I have a sheet setup where someone can enter a construction cost, and a lookup table for the complexity factors based on…
-
User Interface to collect smartsheet data
I have a smartsheet with data, I would like create a UI for other people where when they just type one of the specific data (such as name) and information about that row pops up without even opening the smartsheet. So it is easier and quicker to retrieve data.
-
Replacing form entries instead of copying
I have a smartsheet with a form automation that collects information like a survey. However I want to make it so when an entry with detail such as name is already in the smartsheet it replaces it with the new form data rather than creating a new entry.
-
How do I make a form field's visibility dependent on 2 fields?
Hi, I've been struggling with this with my favourite AI for over an hour now and I've hit a wall. I want to implement the following: if [CheckboxA] show field 1 if [CheckboxB] show field 2 if [CheckboxA and CheckboxB] show field 3 There is no way to do this within SmartSheet forms. You have to have a helper column in the…
-
Time tracking in RM
A teammember is unable to track time to one specific project. They can track time to every other project and the settings are the same as everyone else's. Any ideas?