-
Conditional quantities for pricing sheet?
Smarties, I am creating a pricing form and am stuck on a formula. In the example, the first 4 widgets cost $10. Each additional widget is after 4 widgets is $3. In the preceding cell [1-4 WIDGETS], I have a single-select dropdown of 1, 2, 3, 4, 5+ (as I need these numbers to count the number of widgets sold for anotherโฆ
-
Filter & Total YTD
Hello, I'm trying to filter how many YTD programs I've held of a specific program. There is a column with many program names, and a column with Start Dates. How do I find the YTD total of a specific program? This is what I've come up with so far, but it keeps giving me errors. =COUNTIFS({Program Name Column In referenceโฆ
-
Send Survey results to a specific email ?
I created a survey and I want the survey results once submitted to go to a certain person via their email address.ย Is this possible?ย
-
Count Responses for the Same Answer, for Multiple Persons
I created a survey and used the following formula to count repsonses; =COUNTIFS({2020 IS Employee Engagement Survey Range 3}, "Vin Miliano", {2020 IS Employee Engagement Survey Range 1}, "4 - Agree") The formula works fine for Vin, as his number of responses is 2. I also have another user, Tim, and his response is 2. Howโฆ
-
Summing Mixed Text and Number Column
Greetings. New to Smartsheets. First time question. I have form entries that looks like this: 333 . 11111 - Parts 333 . 22222 - Service I want to sum all entries from the form that begin with "333" and I cant seem to make it work. I dont want to divide my columns. I'm currently using a SUMIF formula and playing with a FINDโฆ
-
Calculate Overdue Documents
I have two dates columns. One is Target Completion Date and the other New Target Date. I have the following two questions: I wanted to know how many documents did not meet the Target Completion date. Total counts. If the Target Completion Date was extended then how many documents missed the New Target Dates. Total counts.โฆ
-
Bring back result based on condition
Hi all, Hoping I can get some help with a formula. I have a date column that I want to bring back a "health result" depending on the 'finish' date. For example if the finish date is past today's date then it would be red and there would be different thresholds for each date range. Is this possible? The "health result" is aโฆ
-
Start and end date columns advanced by one year
Hi all, I'm trying to flip ALL dates in the start column ahead by 1 year and ALL dates in the finish column ahead by one year. We're utilizing Smartsheet as our critical path platform so this is something we need to do year over year and manually updating ~1000 rows is not realistic. An exact date is not the most importantโฆ
-
Help with an IF OR function
Hi, I am trying to write a formula that says that the status indicator in a column should turn red if either a) answer in drop down column is "No," or b) second column is NOT left blank (i.e., if someone adds information to the column). I have been able to get formulas for either of the two functions to work independentlyโฆ
-
countifs formula works in cell but not in sheet summary
Hi, All I have this countifs formula - '=COUNTIFS([Point SysName]:[Point SysName], <>"", [Cable Roughed In?]:[Cable Roughed In?], 1)โ'. When I put in in a cell, it works. But when I put in a sheet summary field, it comes up with an error message of '#UNPARSEABLE'. In the attached photo, the number '2' is the result I amโฆ