-
If and date functions; sorting rows by priority
Hi, I am attempting to create a task priority column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change to: 1. Gray - if the date today is grater than 60 days from my due date column or if my status column has been changed to "Complete" 2. Green - if the date today is…
-
Automating RGB Balls from value scale
Hello, I am trying to automate into a status column a stop light symbol that reflects a value in another column that is on a scale - I am not sure what I am doing wrong... =IF([Health Score]12>= 0, [Health Score]12 < =1.5), [Status]12, "Red", IF([Health Score]12 >1.5, [Health Score]12 <=2.9),[Status]12, "Yellow",…
-
Escalation Alerts or Notifications
Is it possible - whether in the Alerts/notifications or with a formula, to create an escalation based on inactivity of entries. Example: Operators enter the date when equipment is cleaned. this is required weekly. If 2 weeks are missed for entries (14 days), then I want a notification sent via email to their manager.…
-
Converting text to date via formula
Good afternoon. I have created a sheet with a form to capture reservation details for a live performance. There are 4 performance date options and form users identify their 1st-4th choices. Once received, they are assigned a date and the cell in the appropriate "Confirmed" column is marked YES. There are 4 "Confirmed"…
-
#INVALID DATA TYPE formula Return
The first formula below is returning a #INVALID DATA TYPE when I enter it. But in the second formula the equation works and I am not sure why the first one is not. What am I doing wrong with the Fiscal year part? does not work: =SUMIFS([Total With Service Charge (18%) if Applicable]:[Total With Service Charge (18%) if…
-
Building a red ledger
My apologies I am not even sure how to search of this, but I am trying to build a red ledger. Basically have it set up so there is a required sale every day and anything under, shows negative, anything over just shows zero. So I have 1 column that has the number sold, next is sum of column1 - 5000, the last is column2/100.…
-
Days Remaining Calculation
How do I set a date in the future and then count down the remaining days until that date? For example, my future date is 8/17/18 and each day I want it to show how many days are remaining until 8/17/18.
-
index match formula not working
Hi, I am using the below index match formula which is not working. The MFG Rev 18 area range is a "contact list" column type, and the column used for the formula is a Text type. I assume the formula is not working due to the type, is there another way around this? =INDEX({Mfg Rev 18 area}, MATCH([Start Date]3, {start date…
-
Trying to do a group IF statment
Not sure how to ask this but I am trying to set up a tracking sheet that will automatically pull info from a master sheet. I would like to send out a form from for someone to fill out and all they would need to do is put in the job # into the form, and on the track sheet it will automatically fill in the rest of the…
-
Link if?
Hello! Is there a way to link cells, or even just copy cell/row info, if a specific criteria is met? I am new to Smartsheet and haven't been able to find anything to do this. This is the situation: I am using a webform to create Purchase requests. I have approvals set up. Once the request has been APPROVED, I want specific…
