-
Formula if cell is blank then, if cell is not blank then....
Formula gods, looking for help, please. I'm trying to write a formula that says if the finish date is not blank, then the QA status is Green, if finish date is blank, then go to the days open field and if less than >= 60 and <=89 then Yellow, if days open is >=90 then Red. I can write the individual formulas to get the red…
-
Identify Shift from Submission
I am looking for ideas on how to identify & link a submission using the "Created (Date)" system column. We work shifts either from 07:00 - 19:00 (Day) or 19:00 - 07:00 (Night) and I would like to assign the label "Day" or "Night" to a submission based on the above criteria. Any thoughts on the best way to approach this?
-
Status If/And Formulas
I have a project manage sheet I'm managing that I can't seem to get the formulas right in. The first one has two parts. 1) I want the status to be green if the Planned Completion Date is equal to today or the future. The Status to be Yellow if the Planned Completion Date is 1-7 days in the past and the Status to be Red if…
-
Create Trigger/Alert when Dates Shift Out of Month
We utilize a number of Smartsheets (one per Customer) to track project milestones, including "Projected Invoice Date". The value in this field is formula driven, which works great. I then have other data sheets that pulls the data from all Customer sheets to summarize our projected invoicing $$, per month, based on the…
-
What formula do I use to change cells once another cell changes?
Basically for me it's once an item is selected in the form it will then change 2 other cells in the row. These 2 new cells will have email addresses that will be used for an automated status emails. I am new to the formula/functions in Smartsheet.
-
Countifs and <>
Sorry for the simple question, but I'm braindead. From a reference sheet (See 2n photo, I need to count # of Agents in first sheet photo, if Year is =Year@row and Agent Status is <> "Not in Agent Count". For some reason, I keep getting 0. Apprecaite your help! Sheet Referencing: Sheet with formula in Agent count column: If…
-
Find cells in column that contain 2 specific words
Hello Community, I'm using a helper column formula and trying to identify cells in another column that contain the words "Basics" and "Clinical". The column I'm referencing is "Event Name". I tried this: =IF(COUNTIFS([Event Name]:[Event Name], AND(FIND("Basics", @cell) = 1, FIND("Clinical", @cell) = 1)), 0, 1) and it gave…
-
Join and Left Formulas
I am trying to Join three columns, the first two are full names the third is a auto generated number. I need the first letter of each column and then the number. I've tried to use Join and Left but it is not working for me, the Join work or the Left works, but combining them is not working. The N Section below is the…
-
Help with Formula
I am trying to create a formula =Program Revenue+PY Rollover-Total Booked however I think because Program Revenue is also a formula it is causing an error. Help is appreciated.
-
Behavior of "=" Operator
On several occasions I have confused myself, not understand why I am getting a #NO MATCH error when comparing a Text/Number column to a Auto-Number column, and I have realized why... Results in False 001 = 001 099 = 099 Results in True 100 = 100 10000 = 10000 I understand why this is happening, but I do not necessarily…