-
IF formula with Multiple conditions- help required
Hi, I am trying to work out the forumla that is based on a lead time field (manually entered) vs turnaround field (automatically calculated on dates) , the formula I want has multiple conditions which I am struggling to put into one IF formula, would appreciate anyones help - thanks/ I want to have a formula that says: IF…
-
A cross sheet formula that reference back to the main sheet?
Hi all! I'd be very grateful for your help... I have a Smartsheet where I would like to have an index match or vlookup formula or similar, which references a secondary sheet. The problem is that the relevant field in the secondary sheet contains a formula that needs to reference back to the main sheet. I have made up some…
-
Is there a way to refer to the Row URL so that the link to the specific row can be used...
I have clients that get asked to review ticket information and they get informed via automation messages that their input is required. And, yes, those automation messages include the link to the Smartsheet at the very top of the email sent to them. However, they would like the URL for the row to be sent to them so that…
-
Add Dynamic Reference in Formula
Hi, I'm creating a summary sheet, I have a few sheets with the same columns, and I want to add COUNTIF formulas to the summary sheet, I'd like to know if there's any way that the Reference should be a dynamic option, so if a user chooses on the Reference sheet from a dropdown column: Sheet 1, the formulas knows to use…
-
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…
