-
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) -…
-
IF function to return value based on dates
I am trying to get a value when I put in a particular date If a person puts a date in the Target completion field, I want to return a Sprint in the Sprint field. I dont know if I can use the month or does it have to be between? For example =IF([Target Completion Date]@row) is between 8/1/2024 and 8/31/2024 then return…
-
Issue when Converting to Column Formula - #Invalid Data Type
I am working on a Smartsheet to track invoices for contractors and automatically update how much I need to accrue at the end of the month based on the contractor and average price. Each row in my sheet represents an invoice with details such as the contractor's name, invoice date, and price. I need to calculate the total…
-
Looking to COUNTIF with an OR function for a cross sheet formula.
Having trouble with the last part - the Status column is a dropdown with 5 options. I want it to count if it meets all of the entity, type of request and then if the Status is Ready for Approval OR On Hold. The problem with my formula is after the OR part. Anyone have some advice? =COUNTIFS({Entity}, [A]109, {Type of…