-
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…
-
Select Different Colors for Select and Multi-Select dropdown results
Hi! It would be really cool if the result displayed in a cel for the result of a drop-down choice could be a different color in that cel. Also, have that be able to change by status/be filterable. This would make it a lot more intuitive instead of everything just being grey. Imagine the below with the ability for Maine to…
-
Return multiple contacts based on department dropdown list.
Hello, I would like to use a master list with a list of people attached to the department that populates multiple contacts in the same cell depending on what dropdown departments are selected. So Sheet 1: Department Email Marketing Billy@help.com Operations Bob@help.com Sheet 2: Departments (dropdown multi select)…
-
How Can I Automatically Remove Outdated Rows for Updated Project Data?
How can I automatically remove outdated data from Sheet A in my Smartsheet, which pulls project data (weeks remaining and timeline variance) from multiple project summary sheets? Whenever a project's data changes, Sheet A adds a new row with the updated information, but I want to ensure only the most recent data is shown…
-
Alert Automation- Populate Dynamic Column information by Clicking/Selecting instead of {{typing}}
Hi Smartsheet, Please make it simpler to populate columns in the Alert Someone automation. Clicking from a drop down would be much easier than having to type in the {{ }} and the column names. Thanks, Eric
-
Office Clinic Patient Registration Booking
I am looking to set up a booking system for a downtime project to be able to use in our offices (clinics). I would like to be able to see the rooms for that location and the availability for each time slot. Ultimately if a patient checks in they would then be assigned to a room during registration. 2. Is there any…