-
Enhancement Request: Improvements for Contact List columns in Forms
When adding a Contact List column to a Form, if no contacts are listed in the column properties, the field shows up as a simple text entry. If contacts are added in the column properties, the entry changes to a drop down. However, the drop down acts as if the "Restrict values to list only" check box is checked, whether it…
-
Setting Up Automated Transfers between Sheets
Hi all, I'm trying to sort out if it's possible to have information automatically transferred from one sheet to another. Essentially, I'm hoping to create an automated archive that absorbs all information in our primary sheet once an item has been fully addressed. I haven't come across anything in the training videos that…
-
How to Set My Weekly Update Request Form to Blank Cells before the Weekly Update Request?
Hello, I would like for this form to go completely blank on ALL cell-rows before the update request gets sent to the collaborators (not licensed users) every week. I already have the update request set to send every Friday at 9AM to request the form to be filled by the list of collaborators. I just want to make sure the…
-
Color Scale
I read an old thread from 2018 about this, but is there a plan to provide users the ability to do conditional formatting using a RYG color scale based on high/low values?
-
Delayed automatic form entry response
We wanted to create automatic delayed response to a form entry. It would send email back to whatever email was entered into form field 72 hours after the form has been filled. The response would say something like: "Your request has been approved". We wanted auto data stamp column to generate that response but automation…
-
Can you sort rows or filter in the iOS app?
I am trying to sort a list from ascending to descending in the iOS app. Or filter out values less than a certain number. Seems like this would be very standard functionality for a spreadsheet. Am I missing something? Any help would be greatly appreciated.
-
Multiselect Field Option Disables Field as Lane in Card View
I've noticed that in converting fields to the new multi-select format, that this field becomes no longer available as a lane in Card/Kanban view. Was there a reason for this? Will that be resolved soon?
-
Feature Request: timestamp() function
It would be great if there was a way to timestamp the value of a cell. To enter the exact date that an event occurred. Several people have volunteered a modified date column, but something like the following functionality in an if-statement would be really great. =IF(FieldName1 = "blah", timestamp())
-
Card View multiple perspectives
The Card View is awesome, creates verticle swimlanes for each value in a drop-down field. I'm wondering if there is a way to add a second perspective to the Card View from a second drop-down field. The secondary values would render as horizontal sections. For example, the verticle swimlanes might be departments, but the…
-
DAYS360 Formula
I'm trying to move various spreadsheets from Excel to Smartsheet but I keep needing the DAYS360 formula. It is very common to calculate loans based on 360 day years so monthly figures remain constant (at 30 days/mo). I was very surprised to see that this formula is not supported by Smartsheet. Is there a way to mimic it?…
