-
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…
-
Setting conditions for RYG balls
I would like to have the RYG balls automatically adjust based on another status column. For instance, if my outside sales people set the status of a row from bidding to the following: Status "Lost" = RED Status "Postponed" or "Unknown" = YELLOW Status "Won" or "Obtained" or "Negotiating" = GREEN Status "Bidding" =Will…
-
Improvements to Help, Activity Log, Branding, and Navigation
We’re releasing a new update this evening (June 20th), here’s what to look out for: In-line Formula Help—Quickly see syntax for formulas as you type them in a cell. We’ve also revamped our Functions content in the Help Center, which you can find at https://help.smartsheet.com/functions Activity Log—View the Activity Log of…
-
SUM Function is not working properly
Hey Everyone, I'm currently working in an area where my SUM formula is simply not working, my formula is =SUM(ColumnB127:ColumnB133) and it continues to return a value of 25. Below I have provided a picture. I even thought it may have something to do with the value's being linked, and pulled those values into a separate…