-
Sum of a column by cell color?
Not sure if this is possible or not. I was looking into conditional formatting, but didn't seem to find anything that would work. I simply want to get the sum of a column based on the color of the cell in the column. In other words, I only want to see the sum of red cells and exclude green cells. If this is not possible,…
-
Conditional Formatting of numbers
Hi. I have been a user of Smartsheet for a number of years, and still the most annoying feature is the limitation of the Conditional Formatting for multiple cells I have a pretty basic request.... All formatting is based on the value of a cell. * If a cell is in a certain range then change the background colour * If the…
-
Custom Output based on Multiple Variables
Hi - I'm relatively new, have watched videos and searched articles but I'm stuck. I have 50+ training products and a ton of potential job roles and location combinations. I'm trying to use SmartSheet as a "database" where I can select from a set of criteria and have that spit out a custom set of recommended training…
-
Calculate Difference Between Latest Entry and Previous Entry (Dates)
Hello! We are collecting weekly meter reading data (Meter Name, Reading Date, Actual Reading) via webform. I would like to create a calculation in a new column (within the sheet) that automatically calculates the weekly meter usage based on the meter name using current and previous entries by date. *For each Meter Name:…
-
A formula for totaling question
I have a sheet that is tracking issues. One column is a category (bug, feature req, UI issue, etc.). The selections are defined in a pull down and isn't free form. I want to create a widget for a dashboard that shows the total number of each category option. It appears I can't do it directly so I thought of building a…
-
Line Item Transfer to Another Sheet using Formula's
I'm working on a project and am hoping for some advice from the community of experts! I have a sheet that serves as an ongoing list of projects and information about those projects - once a decision is made to either fund the project or deny the project, I'd like that line item to appear in another sheet. My main sheet…
-
Timecard Approval by WEEK, not by line.
Hi Community! Relatively new to SS, so I am thinking this has a simple solution. We are utilizing the timecard template but need a weekly approval from management. As of now, I can only get approval request to work by row. I do not want the managers to have to approve each row of the timecard... rather, just one approval…
-
date trigger formula
Im wondering if there is in smartsheet formula that can transfer task name to another sheet when the date is today?
-
Formating
I want to center the column titles and color them. I like to remove the grid lines from it as well.
-
Automatically Generate Decision Log from Action Item List
I’m looking for guidance on how I would (or if it’s possible to) automatically generate line items on a decision log from an action item log column value (separate sheets). What I mean is, whenever the value of “move to decision log” is selected from the next steps column in the action item log I would like for a line item…