-
Identifying Duplication in a Column - New Form Submissions
Hello, I am trying to see if there is a formula I could use in a hidden column, with a checkbox, where when a new form is submitted (and a new line is then entered onto a sheet) it would alert me if there was a duplication in a certain column. Example: We enter new sales orders into Smartsheets using a form. If an order…
-
Formula for multi-cell status update
Hi all - First Discussion here. I am trying to use a formula that will populate a cell with "Not Started", "In Progress" or "Completed" based on the condition of eight cells in the same row have data in them or not.I have created two formulas that work in part but cannot figure out how to properly combine them.The idea is…
-
How to create totals for different columns for a specific date range
Hi I am struggling to get the total for all the columns in my sheet for each week Monday- Sunday. My entries are created via webform. I need to take into consideration the created date for my weekly time range Could somebody help me please? Thank you :)
-
Sum if formula based on condition in another cell
Looking for help on a formula! I want to sum the Forecast Amount values where the Sales Stage is equal to the value in the Status column. So for example, Status11 is equal to 2 - Qualification. I want the amount in Forcast Amount10 to be the sum of all the instances in the data below where the Sales Stage is equal to 2 -…
-
Formula to display duration of a project
Is there a formula or a work around to produce the duration of a project when given the start date of the project and the end date of a project? In Excel (=DATEDIF(D9, E9, "d") is a simple formula but in Smartsheet what am I'm missing?
-
Creating a New Sheet Referencing Cell Data from Other Sheets
In Sheet 1, I have several rows, each with information about a course being developed in a particular term. The sheet has a list of courses, within four parent rows, one for each quarter of the year (e.g., Parent Winter 2019, with several rows as children, one for each course to be developed in that term). There is a…
-
IF () formula, Change Status Dependate on Date
I would like to build a formula so that status will change to "Red" and type will change to "Renew" when date is past "Expire Date". I've applied the two formulas separately at the top of each corresponding column. But so far it just changes it to Red or Renewed automatically, without the date dependency. Can I make this…
-
Blank display value for Symbols type?
I'm trying to recreate a switch function I've used in Project files to work in Smartsheet. It updates a symbol status column based on %Complete, Today's date, and Finish dates. I'm trying to use the green Up, yellow Sideways, and red Down arrows. Issue is, also need to display a blank in that status column if none of the…
-
IF Formula Based on Selected Quarter
Hi, I would like to write a formula that selects the appropriate sales tax rate with each quarter. I think I may be missing something basic when if comes to IF formulas...Does it matter if the sales tax column was created as a dropdown list? Is there a limit to the length of this formula if I were to add on with future tax…
-
Sumifs formula help
Hi, I am putting together a sumifs formula and it works for all criteria except this situation: With my working formulas, my range is just a column value but now I need a formula with the same criteria but I need to range to be the sum of 2 columns. This is my working formula with a single column range =SUMIFS({2019 Master…