-
Formula with a # result
Goal: I'm basing this "costing" formula off of a cell that is in % format, the format in the "costing" cell is $. If Percent8 Cell is x THEN this # 0 through 0.43 = 50 0.44 through 0.90 = 75 0.91 through 1.00 = 100 What is wrong with my formula? I keep getting an #unparaseable message =IF(AND(Percent8 >= 0, Percent8 <=…
-
Formulas not working in some rows
Hi there, I have this formula running in a field called Contract. This sums up all the pricing across this line. =SUM([Facility Rental]373 + [Curtain Fee]373 + [Chair Fee]373 + [Stage Fee]373 + [Porch Fee]373 + [Lot Fee]373 + [Rehearsal Fee]373 + [Cleaning Fee]373). This is working in some of the rows but not in all of…
-
Calculate Date for Status Change
Does anyone know how to capture or calculate the current date that a status has changed on a task? I'm trying to capture the dates that each task is moved through the status phases of To Do, In Process, Done.
-
Scheduling an Update Reminder like an Alert
This is a test sheet (screenshot attached). I am trying to set up a method to where an Update Request is automatically emailed to the sales rep 3 days after the trigger date (Bid Date). This functionality is in the Alert Module, but in the Update Request you have to manually set a date each and every time; keep in mind I…
-
Auto-Copy Formulas
I was having some problems with standard =this+that*something formula not copying down when I add a row. When I add an IF() statement to the formula, it seems to work. I noticed this, because all of the IF statements in other columns were working, so I thought I'd test the theory (add the IF()), and it worked. Anyone else…
-
formula for date to land on the following Tuesday
Hello, I am calculating a date based on another date: =[Proof to LSI]70 + 49 I would like to add to this formula so that the date will always land on the following Tuesday. Any suggestions? Thanks, Kim
-
=IF formula ???
I am trying to create an alert formula. I need to contact people every 15 days. I have one cell that states "Last contact" and the date, another that states "Next contact"and the date, the third cell, I would like it to state "Contact" in red. Can anyone help me formulate the "Contact" cell?
-
LOOKUP
Can someone please help? I cannot figure out why this formula is not working. Fyi..the Current Designation column is column number 2.
-
Programme RAG
Hi All, I have a roll up sheet for the programme of work, each line is a project that is being worked on or queued for work. Each line has an Overall RAG called ''Overall Status''' for the overall project and I have a metrics table which states the Programme RAG, currently this RAG for the Programme would be manual, i…
-
Revenue per month Formula extending beyond 1 year
I have a sheet that I have created to forecast revenue per month based on forecasted schedules and dollars/project. Currently this just goes for 1 year, but with projects now starting late Q4 2017 and going into Q1 of 2018, I am needing to revise this formula to add a year definition. Would love if someone could take a…
