-
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…
-
Error message: Something went wrong with Resource Management...
Hi, While updating one of our sheets, my supervisor and I continue to receive this error message: "Something went wrong with Resource Management. Please make an update to your sheet and save the changes to try syncing again." Connecting Resource Management to a new sheet has no issues. I am online with a good connection,…
-
Seeking Guidance on Connecting Biweekly Status Reports to Projects and Dashboard Creation
Hey Smartsheet Community! I hope you're all doing well. I'm currently working on optimizing our project management process using Smartsheet and could really use some guidance. Objective: I work for a PMO for state government. We're managing project updates through a biweekly (due every other week) "Status Report" form and…
-
Copy & Paste Contact Cells between Sheets
Currently only able to copy and paste contact cells on a single sheet.
-
Issues with DDUpdate?
Hi SS Community, Are any of you out there using ddupdate.com to support populating your dropdowns from a column in another sheet? Several people in my org are having trouble getting our payments to go through and are hearing nothing from the site. Is this just us or is it a wider problem with ddupdate?
