-
Help With Multiple If Formulas
Hi, I am attempting (Badly) to put together a formula to set dates based on a previous date, but also the timeline is based on a yes or no answer, so if the answer is yes there is one timeframe and if no there is another I also don't want errors if the field is blank. So far I have this; =IFERROR(IF([Client review…
-
A way to automate status/ progress based on % complete, duration and baseline end date
Sorry if this has been solved previously, and for the long message! I'd like to create an auto status column that is based on % complete, duration and baseline end date for each task. I've added 3 helper columns (image attached), but I'm stuck with the formula for the status: -'Days Complete %' is based on the duration…
-
AND/IF formulas
I'm trying to identify the syntax error in my formula. Can someone help me? =IF(Statut@row= "Terminé", "Vert), IF(AND(Statut@row = "En Cours"; IF(Échéance@row<=TODAY(); "Rouge", "Jaune")))
-
Formulas
I have a sheet created in which specific employees are awarded bonuses on. Those marked as completed would receive a bonus. So I need the formula for Status, assigned, Job # and address
-
Custom Serial Numbers
Hi there! I want to be able to assign a unique serial number to each newly populated row. One of the columns, "Type", determines the first letter of the serial number for the respective row - the prefix - and the suffix is a three digit number (starting at 001) that increments by 1 determined by the prefix. For example: In…
-
Extract date from cell into helper column
May 23 2023 02:53PM This is how the date looks when it comes in, (it is pulled in from a 3rd party software via data shuttle). Trying to convert this into a helper column in this format: 5/23/2023 (removing the time stamp) so that I can us it in a report. Any help is greatly appreciated. Thank you, Brandon
-
I am trying to create a formula - If I Select "Yes" then multiply 25 by a specific cell.
The formula works, but it is not solving the equation and is giving me the words of the equation instead =IF([Per Diem Eligible (Yes/No)]@row = "Yes", "25*[# Nights]3", "")
-
What is wrong with this COUNTIFS formula?
=COUNTIFS({Consumer Alerts Sign-up Form Date}, >=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY()), YEAR(TODAY())-1), 7, 1), {Consumer Alerts Sign-up Form Date}, <=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY())+1, YEAR(TODAY())), 7, 31), {Consumer Alerts Sign-up Form Range 1}, @cell = "") I am trying to create a COUNTIFS formula for each…
-
Formula to sum values based on multiple cells.
Hi All, I am managing a material tracking sheet and I need a little bit of help with the following: I need a formula (or some method) to sum values of cells in a column called 'Qty'' based on the info in 3 other columns. So the formula will find all the rows with where the PO No. cells match and the Material Description…
-
Merged: Automation Action to calculate a Variable Value
This discussion has been merged.
