-
What is wrong with my IF formula
=IF([Transportation Type]@row ="Rental Car", "CWT Code Required”, IF([Transportation Type]@row=”Air”, "CWT Code Required" ,IF([Transportation Type]@row=”Train”, "CWT Code Required")))
-
How do I set up a notification for a specific row that contains formulas
I have a row that consists of formulas that are changed by other rows. How do I: Set up a notification for just one row (not column)? Set up the trigger to recognize when the product of the formula has changed? (i.e. if the formula in a column adds up to 150 this week and next week it changes to 200, that is a change that…
-
IF(OR formula for a Checkbox
I believe this is simple, but I am #UNPARSEABLE error. I have 5 approval columns with Approved, Denied or Received. I want to check all 5 columns, if any one of the columns has received, then select the checkbox. Here is what I have now, what's missing? =IF(OR([Approval1]@row, ="Received", [Approval2]@row, ="Received",…
-
SUMIFS ISBLANK/NOT IS BLANK CHILDREN ROWS
Hi! I am trying to sum children rows if the date at column "MUNIS LEVEL 5" is either filled out (NOT ISBLANK) or not filled out (ISBLANK). I am getting an error. Is it a syntax issue? Thank you for your assistance!
-
Map values to date buckets
Hi I have the following table: Sprint, Start date, End date 20.01, 10/01/20, 10/15/20 20.02, 10/15/20, 10/30/20 20.03, 11/01/20, 11/15/20 I want to show the Sprint value, whenever a user enters a date between the dates that are next to the name. For example, show 20.01 when a user enters a date from 10/01 - 10/15. How is…
-
How do I combine the following formulas?
=IF(LEN[Cardholder Employee ID]@row = 9, "Yes") =IF(LEN[Cardholder Employee ID]@row <> 9, "No") Or how to count the number of numerical characters in a cell? the count is not working for some reason Sandi
-
Based on a closed date and a remaining budget can I figure what the monthly spend should be
I want to be able to caluculate based on the contract closed date of a project / remaining budget what will the monthly spend be?
-
Cross cell formula
I am trying to create a formula that will represent the estimated hours per task for all resources allocated for that task Currently: Duration is in days "Allocation % is 5% for the duration of the task "Estimated Work Hrs": =((Duration11 * 8) * [Allocation %]11) 8 is reflective of hrs in a day Since I have more than one…
-
Alert Me When A New Sheet Is Created
Hi there, Is it possible to create an alert, that when someone in my team ads a sheet, I as admin should get notified?
-
% Complete (Showing as a number instead of %age)
Folks, The rolled up %Complete is showing up as a number (image attached), even when the child items are entered in %age. How to convert the parent % Complete value to show up as % instead of number? Thank you in advanced.
