-
Adding 30 or 60 days to a date based on another Cell Value
Greetings, I am trying to calculate either 30, or 60 days from a date, depending on the value of another cell. Example: Cell 1: Date Cell 2: $ Value of less than 50k or $ Value of $50k and up Cell 3: Date plus 30 or 60 days, depending on the value of Cell 2. Any ideas? Thanks!
-
Slow Response Time
Hi all, Is anyone else struggling with slow response times from Smartsheet. I have around 40 sheets that i work on, and 1 tab open. Even simple tasks like moving the mouse and clicking on a cell or an option is taking around 30 seconds to complete the action. I have tried this in empty sheets and still finding the issue so…
-
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.
