-
Natural Language processing for dates
Natural Language Processing to set key dates using the same conversational tone from comments. specify time with descriptions like "Tomorrow at lunch" to instantly populate Thursday's 12 p.m. deadline as a date.
-
Making Column Required
I have done some searching around the Smartsheet community but couldn't find a conclusive answer. Can I make a column required so that if it is left blank and try to save the sheet will error out asking me to enter data. Thanks in advanced. Devin
-
Hidden or Blind Comment Feature
I would love the ability to have a hidden or blind comment feature for end-users to provide comments or feedback without being able to see the comments posted by other people. This would be especially important for intake sheets so the committee members can have conversations about the request in the comments section and…
-
What is the best way to deploy a new version of a form, using the same link?
I have created a new sheet and form for my users to submit tickets through. I'd rather use the same link as the previous sheet, if at all possible, so I don't have to worry about users not saving the new link properly and not being able to access the new sheet. I tried to save over the new sheet with the old sheet's name,…
-
Multi-select dropdown column to pull single value in another column
Hi Everyone! I need some assistance with a formula to extract single value from a multi-select drop-down to individual columns. I got most of the process to work but for whatever reason the formula for control 4 column ends up displaying a incorrect number "12." instead of "12.1" and control 5 column displays the whole…
-
Join Formula with Dates - How to eliminate the time stamp?
I am using the join formula to combine the task name, start date, and end date into a single column that will be used for reporting purposes. The start and end dates are formatted to only show the date, not a time, however when I use the join formula, it's giving me 'Task Name -- ##/##/## 8:00 AM - ##/##/## 4:59 PM" and I…
-
Auto check all check boxes in a column
Hello! I have a sheet with a check box column where end users select the check box to nominate a speaker which will trigger a separate workflow. The issue with individually selecting is that there can be upwards of 100 speakers on the list. Is there a way to have an option for the end user to click one check box or choose…
-
Merged: A cohesive/real-time ability to work with multiple people within a sheet at the same time.
This discussion has been merged.
-
List distinct values based on a criteria and remove blanks
I am making a metrics sheet that calculates what I need to show from a datasheet. The datasheet has columns for the Type (building type is either MOB or Hospital) and Departments (MOB has 12 departments and Hospital has 24 departments) along with a bunch of other columns that have data. In my formulas {CD - } is…
-
How to use COUNTIFS where there are 3 conditions (columns to be referenced)
I'm trying to create a formula in a metric sheet that is referencing another sheet where data is held. I've been able to set up a COUNTIFS formula that references 2 columns so far, but my issue is that it doesn't seem to let me reference a third column using the "formula builder" as below: I'm trying to use COUNTIFS to…