-
Complicated IF formula
I am trying to create a column formula that does the following. If the application is Declined or Withdrawn then cost is 0. If not, then based on each course we offer, it puts the cost of the course. This is the formula I have as of right now but it is very messy and not working. =OR(IF(IF(OR([Application Status]@row =…
-
Conditional logic not working in my form
Hi, I have a form that utilizes conditional logic. We have been using this form for a couple years with no changes, and all the sudden the logic stopped working. Here are some screenshots: In this one, when EUS/US is selected, it should show call ID, which it is doing. But when the other two options are selected, the Call…
-
Grouping in Dynamic View
Hello Smartsheet Community! Is it possible to group rows in Dynamic View? We have experimented w/ Report View and the ability to group like data, we would like to have similar functionality in Dynamic View. Thanks in advance! Greg
-
Sheet Summary Formula for Adding Date Range
I am trying to count how many trainings we have starting in each quarter. I am trying to use: =SUMIFS([Learning Request Name]:[Learning Request Name], [Proposed Delivery Start Date]:[Proposed Delivery Start Date], >=DATE(2024, 01, 01), [Proposed Delivery Start Date]:[Proposed Delivery Start Date], <=DATE(2024, 03, 31)) I…
-
Campaign Spend Flighting by Month
I am trying to create a formula that can calculate spend by month based on a campaign flight and total budget. Ideally, I would have a column for each month. I've tried using a helper formula which worked in excel of =MAX(0,MIN($E2,EOMONTH(C$1,0))-MAX($D2,C$1)+1) to get the days in a month and then multiple daily spend by…
-
CountIFS based on rolling FY and item.
Hi Everyone: I am trying to count how many of X has been completed (based on completion date) in the current FY based. Ideally I'd like the count to automatically update what the current FY is. I think this should be a simple formula, but for some reason, I'm at a loss. Thanks in advance for your help.
-
CountIf AND
Hi I am trying to write a CountIF AND Formula for Chart The Column choices are Case Carrying vs NonCase Carrying The rows are Region 1 to Region 6 So for example: Countif the person is in Region 1 AND is Case Carrying. I keep on getting different errors. Thank you for your help!
-
Query Formula Help!
I am currently creating a search query that will allow anyone to search for a name and get the corresponding information. For some reason, when I try these different formulas, I am receiving the error message even if the name is correct. I've included my references in the formula as well. Can anyone help with this? Current…
-
Evaluate a date and return week #
I have a date input in a worksheet and need to somehow lookup what week # the date falls in. My weeks begin Monday and end Sunday. Screenshot of 'Date Range' worksheet below. So if my input date in a separate worksheet is 03/15/24 I want to return 11. I am using this in a 'LookUp' worksheet. Screenshot of 'LookUp'…
-
How to create a formula to show last day of the month
I am trying to create a monthly timeline template, where once I set the start date for the project, the 'Billing Month 1 start' column collects the date and the following column 'Billing month 1 Close' column indicates the end of that month. From there The following 'Valuation 1' column is the result of the prorate then;…