-
Smartsheet Formula for Multiselect cell based on time
Hi, I have created a form for our clinical therapists to enter type of service or referral provided for particular clients each week. I want an automation that takes this data and lists services provided to a particular client on another sheet if it was completed in the past week. The formula I've been working with is:…
-
Allow display of destination sheet full name in the Edit Automation dialog when moving copying rows
This is a simple request to allow visibility to see or display the full name of the destination sheet in an existing automation. Here is the use case: 1) I have created an automation whose action is to move or copy a row. 2) The name of a destination sheet that is selected is longer than what displays in the Edit…
-
Allow editing of column type when conditional formatting is disabled
Currently, 'Column Type' can only be edited if it is not being used in a conditional formatting item. I understand there are probably computational limitations with the sheet trying to re-apply a format to an item type that no longer exists under a column that still exists (would probably crash/freeze), but the only…
-
How can I change the Card View to show a different column?
Currently my Card View is showing my "Status" column and I would like to change it to the "Assigned to" column.
-
Can I conditionally format a cell if it contains text from a range consisting of multiple rows?
I have a column containing text (multiselect drop down) that I would like to eventually conditionally format based on the presence of matching text from cells in a range made of multiple rows. Here is fictitious data in an excel format for simplicity. Sheet 1 Range 1 (Column C) contains the data I want to format based on…
-
Merged: My charts randomly errored out, but I haven't touched the metrics that feed them
This discussion has been merged.
-
Hi, what is the best formula to collect a text in a range of column and return it into main column?
-
Change calendar (column type: date) to years (not months)
Hi all, Just a quick question - when using the column type 'date' in a sheet, is it possible to make the calendar which comes up for selecting the date in question a 'year' calendar rather than a 'month' calendar? Many people using the sheet/form will be inputting dates from about 50 years ago, so a calendar by month…
-
Multi-Step Workflow: Creating and Linking Forms with Unique Identifiers
Good morning! I'm trying the following in Smartsheet: 1. Create a form that has a field to input multiple emails, each submission has a Unique ID. 2. When the form gets submitted, it will send an email to the emails in the submition with a new form of a different sheet. 3. Once the second form is filled by the email…
-
Dashboard Chart [Range Feature], Sheet Helper Column [Trend] and Quick Folder Navigation
Hi everyone, I have noticed there are a lot of features that have been discussed in the past, however they have not been implemented yet, not sure why because they would make life easier. 1st- Implement a feature within Dashboards so that we can resize the range of our charts without having to manipulate the data, coloring…
