-
IF Function With Multiple Drop Down Selections
I am not sure how to "Nest" if functions for my application or if I need to use the "AND / OR" functions with it. Essentially, when my field team updates the [Field Status] column I want the appropriate colored circle to update in the [Risk Status] column. Red = Delayed Gray = Not Started Yellow = In Progress Green =…
-
Check box if multiple conditions are met across 2 sheets
Good morning, I have 2 sheets Sheet A: Job #, complete(Checkbox) Sheet B: Job #, Reason, complete(Checkbox) The goal is to have a formula that will check the box in the complete column on Sheet A if the Job # matches between the 2 sheets, the Reason column on Sheet B is "Screens", and the complete column on Sheet B is…
-
Formula to check a box if the date in another column is the current month
Looking for a formula to check a box if the date in another column is the current month. Needing this to set up a process in which I can filter to Month to Date
-
Invalid formula error using IF AND
Hello, I'm in the process of converting an excel spreadsheet into a smartsheet, but I've run into a problem. I'm trying to split 80% of a cost over a duration and then take a two month break before showing the final 20% on the third month (month breaks should appear blank). The first part works, but I can't figure out how…
-
Is there a way to convert a large number of contact cells at once?
I have over 5000 rows in a sheet that has been exported from ServiceNow. Every row has a contact cell that is filled out with a raw name, no company email. Is there a way of converting every cell into the respective company email for that person at once? The manual method, typing their name and selecting the pop up, will…
-
How to import multiple rows of contacts to a single multi select contact column
I have a source sheet that has a form that collects email addresses. I want to import these email addresses to a column in another sheet where these emails will be used to grant access to a dynamic view. The Agency Name column in both sheets is the reference column. The contact 1 column in first sheet is a multi select…
-
Join Sum IF Formula??
Good Day all, just checking to see if this kind of formula is even possible so bear with me for the explanation. I have a list of Dealers broken out by their budget names. So Dealer Name can have a 1 to many relationship with Budget Name. I need a formula that will total the budget for a given Dealer. For this Example: "Ag…
-
How to write an if or formula with either or return?
I am trying to write a formula that says if the Department column says Pharmacology then return "Pharm" or If Department column says Biology then return "Bio" Thank you in advance. This is what I have that isn't working: =IF(OR(Department@row =Pharmacology, "Pharm",IF(Department@row =Biology, "Bio")))
-
Formula for days of week a ticket was submitted
Hello, I am looking for a formula to put the days of the week a form was submitted. i.e. monday, Tuesday, Wednesday, etc. I already have a created date column which i need to stay as it is but want another column for the specific day that it was.
-
WEEK # in Month Calculation
Hi there, I'm using this formula to calculate what week number in a month a week is. For example 1/1/24 would be week 1 and 1/7 would be week 2, 1/14 starts week three etc. I'm getting 1/14 coming through as week 2. Any suggestions or ideas on how I could clean up this formula to function properly? =WEEKNUMBER(Date@row) -…
