-
Auto-populate form responses from another sheet
Good morning! I currently have an intake form for basic requests for one of my departments. I also have a separate intake form for larger projects that need project management involved. What my ideal situation would be is that when the status on the Basic sheet changes to something like "Needs PM", it would have an…
-
How to populate duplicate numbers into sheet?
Hello, I have one main sheet that tracks all incoming DRR #'s and every row has a couple of names in it. I want to build another sheet that tracks names based on the DRR # but want it to populate in different rows, like below. So two people are on 0001 while in the main sheet that would only be one row
-
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