-
Lookup if date is between 2 dates, then return an associated value (same sheet)
Hello:) Is there a way to lookup a date, determine if it falls between 2 dates (fiscal year quarters), and then return the corresponding value? ie: Date: 1/29/2016 Fiscal Year Q1: 1/1/2016 ~ 3/31/2016 Fiscal Year Q2: 4/1~June 31/2016 etc So, the formula would check to see if {date} (1/29) is between 1/1 and 3/31, or…
-
Formula Help please
i have a column titled # Wins and wound up with a percentage towards my Wins goal. That said i want to use RYG lights based on how close i am to the goal. So here's what i wrote but i know i'm missing something. Any help would be much appreciated. =IF([# Wins]5<=.66,"Red",IF(AND([# Wins]5>.66>.9,"Yellow,IF(AND[#…
-
Match Two Entries from Two Separate Form Sheets, Assign Status
I have an "Assignment" form that creates a system generated number. The crew foreman will use this form for their assignment, then they will populate a "Production" form using the system generated number from the "Assignment" form to reflect the production done for that assignment. I'd like have a RYG ball on the…
-
return list from another sheet
Anyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column. There will be several matches per ID, e.g. Matt worked item 1.. 2... 3.. and 7. I want to return the information relative to that ID for those entries. Thanks in advance!…
-
Circular Reference Issue
So I have two fields I am trying to create a formula. The first field is Today's Date, in which it is autopopulated with the current date. I have a second field name Calendar End Date, I am trying to create the formula in this field. What I am trying to do is create a check that if Today's Date is greater than the Calendar…
-
Summing of colored "conditional" cells
Hello All, I am trying to count or sum how many colored cells there are within a row. The rows consist of test questions and are set to turn red if the condition is not met (answer is incorrect). Is there a way to sum all of the condition not met cells? There are 25 cells that have conditions in them.
-
Nested IF Then And Statment
I am trying to finalize a Nested If Then /And Statement. In one of my logical functions, I am trying move to the next condition if a cell has a date input into. When I try to use the logic if cell > 0, it returns an error. What would be the best method for moving the formula to the next logical statement?
-
cell reference based on date
We have a yearly schedule for all our field guys that is updated a week prior and sent out to the field so everyone knows where they will be working for the upcoming week. My question is can I tie a roll up sheet to the master schedule sheet that I would input a date on the roll up and based on that date grab the matching…
-
Help on formula: countifs with multiple criteria
Hi everyone, I need help on the below formula. I am trying to get the number of active projects based on the columns Section and Stage (see attached image). The 2 sections are called Food and Non-Food. The active stages are called Planning, Strategy Decision, Tender, Evaluation and Contract. Other terms applied in this…
-
QR CODE
Hello Samrtsheet Community! Just getting started with smartsheet. Is it possible to publish a sheet, embed it on a website...YES but then be able to create qr codes that would point to the particular matching row. For instance. If we manufacture a "widget" and each widget was unique and had a special serial number.…