-
Improved filter on automation
Hi Smartsheet, I'd like additional optional filters in sheet automations. Examples: filter by notifications, filter by document actions, filter by sheet changes, etc. Looking for to receiving this update soon Thanks! Eric
-
Merged: Allow editing of column type when conditional formatting is enabled
This discussion has been merged.
-
UPPER formulas
Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
Issues with Convert to Column Formula
Hi, I have a column that I'm trying to convert to column formula but won't because "The column formula syntax isn't quite right" and gives me Smartsheet's help article for more information. The column's type that I'm trying convert is "Symbols" and is the Progress Bar. The Formula of the attached example is: =IF([RPM %]851…
-
Merged: certain cells remain locked until specific data is entered in another cell
This discussion has been merged.
-
Filter By If Attachment
Hi Smartsheet, I would like to be able to filter by attachments (missing or attached), comments (posts or missing), row locks (locked or unlocked). Thanks, Eric
-
Data Table: Automatically Updating Source and Target Sheets
Hi all! Coming to the experts for this… My company has 20k+ employees, so I cannot have all their employee information on one sheet. Instead, I've broken it up into two different sheets: one for executives; and one for non-executives. I'll refer to these as the "main sheets." I also have different sheets for each of our…
-
Conditional Formatting for Duplicates
Adding the ability to do conditional formatting by column, similar to how I would flag a column for duplicates in Microsoft Excel.