-
How can I take a concatenated string and feed it into a form as an option?
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this.. 2019_Jun_Fab5_Skyworks…
-
Unparseable error being returned
I am not finding the error in my formula, Client is a text field and Start and end dates are Date fields. Any help would be greatly appreciated Regards Michelle =IF(AND([Client]1= "In Progress", [End Date]1 < TODAY()), "Moderate", IF(And([Client]1 = "In Progress",[End Date]1 = > TODAY()), "Mild",IF(And([Client]1= "Not…
-
Sumif or ifs...
Hi, I want to sum a column based on multiple criteria from one column. I have accomplished this in the following way: =SUMIF({Stage}, "Proposed", {Volume}) + SUMIF({Stage}, "Sold", {Volume}) Is this the best way to do this or is there a cleaner way to accomplish the same thing. Thanks!
-
Graphing Sumif Data for Date Specific Criteria
Hi Newbie here... My first attempt at creating a graphical / chronological representation of Date specific ALLOCATION subtotals has resulted in an #invalidoperation message. Goal is to show Users combined ALLOCATION on the Y-axis over time increments (wks, mo, etc.) I'm sure you guys have already done this one so any help…
-
nested ifs with greater than less than- #unparseable
Wrestled with this enough. Need to call in a friend. Can anyone figure out what is wrong with my formula? =IF([Last review date]1> 365), "Red", IF(AND([Last review date]1 < 365, [Last review date]1 > 275), "Yellow", IF(AND([Last review date]1 < 275, [Last review date]1 > 0), "Green", "")))
-
Can I Auto Assign Tasks to Myself?
When creating a new task can I have it automatically assign it to myself?
-
do not run formula if cell is blank
Hello, I am a new Smartsheet user. I have search some previous inquiries on this topic and tried the suggestions but I cannot seem to get it right. What do I need to add so the formula will not run if the check-in and check-out dates are blank? =NETDAYS([Check-In]1, [Check-Out]1 - 1) Thank you so much for your help.
-
Combining "IF" formulas with "IFERROR" formulas
I am attempting to return a simple YES or NO if a company I have is in another sheet. I created a match formula in one column and in the adjacent column, I was hoping to do a simple IF statement to return the appropriate results. Due to the companies which did not return a match being populated with a #NO MATCH error, I am…
-
Determine entries in a dropdown from a formula
Does anyone know if it is possible to select each item in a dropdown where you might have one or more entries, and separate each one in a formula to calculate hours * rate? Or a work around if possible. My current formula works fine for one entry as follows with the [Assigned To] column: =SUMIFS({KCPL Hours _#OF HOURS},…
-
Help using join & collect function with multiple criteria & having the delimiter be a semi-colon and
I've been able to successfully use join and collect function with 1 criteria, but not two and am also curious if I can have the results within a cell space to look like Ctrl+Enter was used after each one to be able to easily read through all of the results. Working formula with 1 criteria: =JOIN(COLLECT({Product Roadmap…
