-
Lose data and dropdown list when I apply a column formula
I have a working cell formula that takes the parent value and adds it to the cell: =IF( COUNT(PARENT()) = 0, "", PARENT() ) But when I apply this as a Column Formula, it wipes all existing cell data in the column and also restricts the ability to use the Dropdown List column type function. I thought I could change the…
-
Combining Countif & OR Function
I am trying to write a formula that will count the number of rows where either column A (External Successor) is not blank OR column B (Internal successor) is not blank. =COUNTIF(OR({Internal Bench} = <>"", {External Bench} = <>""))
-
Need help correct a complex formula
So, I am working with this formula, which works great, but I need to throw in a CONTAINS aspect into it...and what I am trying is not working. Current formula (that works): =AVERAGEIF([Project/Task/Issue/Risk Name]:[Project/Task/Issue/Risk Name], ="Stage 2", [Actual Duration]:[Actual Duration]) How would you add in the…
-
Use of IF AND OR ISBLANK
I would like to write a statement that writes Pending if true and Complete if false. The criteria for Pending are as follows: If start date > today, and end date > today or end date is blank (where Start Date and End Date are columns) Here is the statement I wrote, but I keep getting Incorrect Argument Set. =IF(AND([Start…
-
Template Set: Marketing Request Management - Standards - Scope of Work cells
I am following the initial setup steps for the Marketing Request Management template set. In Step 2.C. customize the sheets for your project types and team, when I change the cells in the Standards - Scope of Work sheet, it breaks the communication to the Intake Sheet and Form, and gives me an error message "Incorrect…
-
Setting up an Average Filter across multiple columns
Hello All I'm new to Smartsheet's and still learning formula. So hoping someone can help with this for me as I'm struggling to figure out what I'm doing wrong? I require a sheet that will give me the average number of hours an organizer has spent on a completed project per given month See above When creating the formula I…
-
Looking for the most recent date
Hi there, We have a internal learning courses that people can do to earn 'badges', there is approx 14 badges, each badge has around 5 units that need to be completed. When a unit is completed the person fills out a form which goes into a smartsheet to then be sent to an approver (once approved info gets sent to sheets for…
-
How Can I Create a "Stamp" of An Original Value?
Hi - I'm trying to create a rule/process whereby every time a row gets added (not changed), another cell gets "stamped" with the value. This is so I can have the stamped column as a reference of the Original value. In my scenario, it's a Total. So a row will get added, and in that row is a Total Column. I want to create a…
-
Updating Sheets Dynamically off Master Sheet
Hi! I am trying to create a solution for one of my clients and am hitting a mental roadblock. What I'm trying to do is simply update multiple sheets based on adding a row to the Master Sheet. I don't want to use the Copy Rows function for a few reasons, and this would be something I could solve with a Report, but I can't…
-
Is there a conditional formatting rule that shows if a date is more than X years in the past?
I have a sheet where I would like one column of dates to be conditionally formatted to show if the date is greater than 5 years in the past. I can only find the function for "in the past" without any way to add to the formula how far in the past. Is it possible to set parameters on past dates? It seems like this should be…
