-
Nested IF AND & OR
Hello, I'm looking for a good formula to collect the number of remaining days to work. This works fine: =IF(OR([Assigned to]110 = "User1", [Assigned to]110 = "User2"), [Closing date]110 - TODAY(), "0") but If I want to add one more condition like at row status it doesn't works: =IF(AND((OR([Assigned to]110 = "User1",…
-
Date Formula based on Last Modified is off
I made a column i called Status Date. I used the Formula: =[Last Modified]1 so that it would just display the last modified, but also have the option to be over ridden manually if need be. My problem is that the Last Modified is showing Today (7/20/2017) but my Status Date field, which should show the same date, is showing…
-
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
