-
Single-Use Checkbox (or dropdown) - Can it be done?
Hi all! I looked in the forums and I didn't come upon any which matched this - but if you're aware of a similar thread, please link to it here! We are looking to find a way to make a checkbox or dropdown option a single-use type thing. Basically - we track travel in a large sheet - and part of the information we collect…
-
Project Dashboard Generator
I am trying to develop a dashboard generator so that I don't have to recreate every report I use in our dashboards each time we have a new project. I would like to be able to select the project number in one location and have all the reports reference that project number to pull data from their respective sources, then…
-
Find Value in List in Cell
I have two sheets---one with a list of program that includes rows with a cell that has a list of course prefixes. EXAMPLE: ROW 1--->Doe, John | doej@xx.com | BUS,CUL,MGT ROW 2--->Smith, Elle | smithe@xx.com | HOS,SUS Each row has three columns: name, e-mail address, and course code prefixes. On the second sheet, I want to…
-
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…
-
Conditional Collect Formula
Hello, I am attempting to sum a range of numbers that meet multiple conditions. Data is input into my sheet with a time stamp and a box type(C1,CX etc.) I would like to sum the numbers that are of each unique box type AND are the first 10 timestamped inputs of the day. That is, sum the first 10 C1 inputs of the day, first…
-
Finding preceding dates
I've created a productivity dashboard for myself and need to find a formula that returns the previous months so I can reference them in a COUNTIFS statement. I have a formula which works fine BUT it doesn't cope when the date crosses a year boundary, ie if the month is September (month 8) my formula will get August's stats…
-
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…
-
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.
-
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…