Formulas and Functions
Archives for July 2021
Discussion List
-
Conditionnal auto numberingIn Formulas and FunctionsHi there, i'm looking the possibility to generate or not a number depending of the value on another column. For ex, column A : Yes/NO Colum B autonumbering If A = Yes, i will have a auto number, if no, the field stays blanck. Many thanks…Answered - Pending Review 8 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
How can I incorporate 'IFERROR' in the below formula?In Formulas and FunctionsIn certain circumstances there will be no date in both ' CAT - Date of Last Activity' & Date of Last Activity plus 7 years. Therefore I receive the error message #INVALID OPERATION. How do I add the 'IFERROR' function to the below form…Answered - Pending Review 6 views 5 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Filter Formula QuestionIn Formulas and FunctionsI'm working with a large list that I would like to automatically filter according to items selected in a related column. For example, if a user selects Client A in the Client Column, I only want the list items associated with Client A to a…
-
Add Summary Value from Sub TasksIn Formulas and FunctionsHi all, I have a project tracker that has been created from a project template then manipulated. The template was pre-programmed to calculate/populate the summary value for the Preparer % Complete column but I would like the Reviewer % Com…
-
Get value from another sheet based on value from source sheetIn Formulas and FunctionsI am trying to get the proper or most efficient syntax to take a Contact Name from a source sheet and match the value in a second sheet to then bring back a value from the matching row. I am attaching a screenshot. Looking for accurate s…
-
same formula is not working in different columnsIn Formulas and FunctionsHi Experts, I use the same formular on different columns of my sheet. BUT in one column I get the wrong results. Here works perfectly and shows the red, green, yellow dots when it's needed, =IF([Dev sample needed?]@row = "", &qu…Answered - Pending Review 10 views 3 comments 0 points Most recent by Bassam Khalil Formulas and Functions
-
Formula for lightsIn Formulas and FunctionsHi all, I have a sheet that contains fields for "Preparer Due Date" and "Preparer Status" and am trying to add in the following logic to a formula: Blue = completed Green = task not started or in process that are due …
-
Same formula returning different results on different sheetsIn Formulas and FunctionsHello - I am trying to create a new version of a helper sheet. I have a formula that is working on the old version, but when I copy it verbatim to the new sheet I get a #Invalid Operation error. Here are the columns on the sheet the for…Answered - Pending Review 8 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
IF statement using AND to generate colored symbolIn Formulas and FunctionsHello! Can somebody please help with the following formula? I am trying to generate the colored symbols (Green,Yellow,Red) based on the percentage of tasks complete along with the go live date. I am able to get a single If statement to ge…Answered - Pending Review 10 views 1 comment 0 points Most recent by Bassam Khalil Formulas and Functions
-
Linking the same date from one cell to a second cell on same sheetIn Formulas and FunctionsHi Gang, I am having a hard time trying to use the date entered in one cell to another cell in the same row from the same sheet. The column I want as the target is RECEIPT DATE and the column for the duplicate date is START DATE. I have tr…Answered - Pending Review 14 views 4 comments 0 points Most recent by Paul Newcome Formulas and Functions
