-
Auto-populating formula when pasting multiple rows
Is there a way to populate formula in columns if multiple rows of data when pasting several rows to the columns next to formula column? I would be willing to use CTRL +D, but it does not work in either of three browsers I have.
-
Formula for Sum of # amount and Dollar Amount
I am trying to create a Dashboard to show two things: #1- To show how many (#) of each industry that are “wins” and how many (#) of each industry that are “forecasted”. The columns are titled "Industry" and the "Stage" column has the information for Wins and Forecasted. Wins= "5 - Win" and Forecasted = "0 - Lead", "1 -…
-
Display multiple Values depending on selection
Hi guys (1st post!) I'm trying to display different numerical values in a cell depending on what selection is in another cell's text dropdown. Example Dropdown choices.. Bob, Bill, Ben.. Cell A1 In Cell A2 I want to show '1', '2' or '3', depending on the A1 selection. I've been trying to use IF statements, but can only get…
-
How do I use a countif formula to count the number of various priorities?
I have a column for priority which returns symbols. Exclamation = high, dash = medium, and down arrow = low. I have tried various formulas and nothing is working. I basically want to know the amount of highs, mediums, and lows in my sheet. Help please! Thanks, Dacey
-
Need help for a formula
Hello everyone, I am pretty new to smartsheet so thanks in advance for your help. I am creating budget template sheet, and I have a BUDGET COST column, an ACTUAL COST column and a DIFFERENCE column. When my actual cost column is blank, the difference automatically calculated like if it's at 0. Let's say I have an estimated…
-
Using Addition and Multiplication in the Same Formula?
Hello everyone, I am trying to calculate an amount based upon the sum of two numbers. If you look at my screenshot, the highlighted Hotel and Transportation budget amounts are based upon the # of Days Onsite plus # of Travel Days. I need the system to be able to add those two numbers together and then multiply it by the…
-
New User Help - formulas and ranges
Hi, I'll try to describe in detail what I want to do and would appreciate any help you can provide. I have a range of cells that show Red,Yellow or Green Balls and this is used to check the status of each stage in a project. I would like to also have a cell at the top level of the project that displays RED if there are any…
-
Numbers importing as Scientific Notation
I am working with PO#'s in a smart sheet and joining this data with a SQL database to combine a few tables. I use a visualization program called DOMO that I use to import the smart sheet data and the SQL data and join within the program to make one dataset. The problem I am having is when I import the smartsheet the…
-
Calculating total hours worked in a shift
I'm trying to create a weekly work schedule for all of the employees at our company, so that we can see the start and end of shift and total hours worked per day and per week for each employee. I contacted the Smartsheet team only to find out that Smartsheet doesn't currently support time based formulas (which is such a a…
-
Calculate Total Number of Dates within a Month per Department
Hello, I am a total newbie with SmartSheet and on the struggle bus with this calculation quest. Here is what I am trying to do: I have a sheet entitled 'ES Monitoring' that each department needs to fill in at least daily to track safety behaviors within their department. The columns in this sheet that I want to summarize…