-
Change drop-down option in one cell based on data entered in a different cell
I am looking for a way to automatically select a drop-down option in one cell based on the data entered into a different cell. Monthly we track target goals against actual goals. The target goals stay the same throughout the year, however the actual goals are updated monthly. Based on the actual goals, monthy we determine…
-
Sumifs That Excludes Parents
Hello, I am working on an ever expanding project timeline that has 100's of parent tasks that flow into potentially up to 10+ levels of parent tasks, with children tasks at every level. Given the granularity of the task management and the timeline being outwardly facing, "=sum(children())" is used on every parent task to…
-
Upvote Function / Brainstorming Layout
Does anyone have a template or is there a video that shows how to create a sheet that has an "upvote" or "voting" function of any type? Ideally what I'm looking for is a way to have different product ideas listed out and then allow for our team to vote on which items they like the most.
-
How to use Smartsheet for event planning
Hey there, I'm working with a group to start using Smartsheet for event planning and looking for recommendations on how to set something up for a workback from the event date for task tracking. Just looking to see how other people set up their sheets so I can potentially streamline what I'm doing. Thanks!
-
Smartsheet Desktop App Keyboard Shortcuts
Hello, I was wondering if anyone knows whether the Desktop app has extra keyboard shortcuts for "Go Back" and "Go Forward"? For instance, when working on a dashboard on the web and accessing a report, it was always possible to use a keystroke to return to the dashboard. However, I haven't been able to do this in the…
-
Using the same field across different forms in one sheet
Hi there, I'm working to build a request management system using forms where requestors will simply see a dashboard with icons/text and can select the type of request they need to submit. Since each request is quite different and I want to track the different types of requests, I'd like to list "Request Type" in each of…
-
Merged: Allow editing of column type when conditional formatting is enabled
This discussion has been merged.
-
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…
-
User Management removing someone from plan improvement request
When you remove a user from your company enterprise plan it would be fantastic if that would trigger the option to remove them from groups they are in and shared to items all in simultaneous steps. Our IT team removes them from plan however they are not checking the other options and it creates more cleanup now for group…
-
Merged: My charts randomly errored out, but I haven't touched the metrics that feed them
This discussion has been merged.