-
COUNTIF with OR condition
Hello Everyone!! I'm trying to create a formula that counts all the "Not Started" or "Completed Late" from the same column [Action Plan Status] I'm Trying this: =COUNTIF(([Action Plan Status]:[Action Plan Status], "Not started"), OR([Action Plan Status]:[Action Plan Status], "Completed Late")) But it gives me: #UNPARSEABLE
-
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 =…
-
Calculating time
Hello All, I'm a new user to Smartsheet and am trying to figure out the formula for calculating time. I have a start time column and an end time column and am trying to figure out the formula to calculate the amount of time in minutes. Any help would be appreciated!
-
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
-
Why is a formula not triggering unless someone opens the sheet?
Hi there, I have 150 sheets that individuals use as time sheets. The sheet has rows for all the dates for a quarter. I have a "Current Month?" check box column in the sheet that checks the cell if the row date is in the current month. It uses this formula: =IF(MONTH(Date@row) = MONTH(TODAY()), 1) I have another check box…
-
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!