-
Copy Sheet Summary Field on a Sheet
The ability to copy an existing sheet summary field and edit to save with modified formula.
-
Formula that combines Contains and OR to search for values in one cell
Howdy! I am new to smart sheet, and have the programming knowledge of a 1st grader :-) I am attempting to write a formula that returns a specified value IF it finds ANY of the specified values in a cell (that's within the same row). I also want to know if the cell is NULL or if ANY of the values are NOT found. For example:…
-
How do you use the keyboard to move to the next cell in a row after selecting items in a drop-down
I'm challenge by this situation and the only way I have worked out how to do it is to use the mouse to click into another cell. What happens is, after I have made a selection of one or more options from a drop-down list, the following keyboard commands result in undesirable effects: Tab or Enter while mouse is hovering…
-
Help with a Rolling 12 Month Formula
Hello, thank you for taking the time to look at this and I appreciate any assistance anyone out there might be able to supply. I'm trying create a Rolling 12 Month Formula and running into an issue getting it to work. I have multiple programs on a sheet that have metrics and are nested under a blue header row. The data…
-
I cannot convert my if statement to a column formula
I have an if statement referencing another column named "Country" - I want to define this if statement into a Column Formula but it says "the column formula syntax isn't quite right". This is my IF statement. =IF(Country1 = "US", "01-440-0187 (US)", IF(Country1 = "Canada", "01-440-0188 (CA)", IF(Country1 = "Mexico",…
-
Form submissions
Is there any way to track forms that have been started, but not submitted?
-
Harvey Balls Using Formulas & Multiple Columns
Hi all! I am trying to determine what formula to use when calculating Harvey Balls using two different column details. Harvey Balls are in the "Corrective Action" column. What I want to do: Harvey Ball to be Full when all children rows are checked in "done" column AND there is text in the "Response" column Harvey ball to…
-
Improve Cell History on Row Moved Automation
It would be nice to be able to see what sheet the row came from rather than just that it was moved from another sheet.
-
Formula Help Within Sheet
Alright, SmartSheet community. You've always been good to me with helping out. I've got a real "stumper" here. Let's say I have six columns on my sheet (in reality there's many, many more; but these are the ones relevant to my question): Start Date (a Date/Time column type) End Date (a Date/Time column type) Allocation %…
-
Smartsheets Budget Forecasting
Hello, I am trying to create a custom sheet. It would be a calendar with a nested daily budget. For each day of the week we would be able to update the expenses or add budget forecasting. It should also show the running monthly and yearly total.
