-
Sumif Formula
I’m trying to total the number Enrolled Students if they meet the criteria of being in the Eastern New York Region. I’ve being going in circles with the sumif formula and keep getting an error message. I really struggle with formulas -- even ones that should be simple. Can someone help me write it? Thank you in advance!
-
Contains Formula
Hello, I am trying to make a CountIfs formula that counts across a different spreadsheet, on if the comments cell contains the words "Moved", "Delayed", "Rescheduled", "Canceled", then output the number of these delayed cells. Having some trouble getting this to work as I think an OR statement is nested somewhere in here.…
-
Countif Formula based on Column
I am looking to find a formula that will count if it is a quarter column. My sheet has columns - Fiscal Year, Quarter 2/3 (etc.) and then Monthly breakdowns. FY1 Total | Q1 Total | Jan | Feb | Mar | Q2 Total | Apr | May ... And continues on for a couple of FY. I want to get a count of how many quarters have a value in it.…
-
Right and MID formula to pull from details sheet
I have imported my excel budget and details sheets into Smartsheet and unfortunately my formulas don't import correctly. I have struggled with rebuilding my formulas from excel to Smartsheet and that is the case with the below: =RIGHT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255),5) How do I rewrite this in…
-
If checkbox is checked, add text to cell
Hello, I have a checkbox in a column named "Completed" I'd like to have a formula that adds the number "100" to a column named "% Complete" if the box is checked. I've read other posts and cannot get this to work. thanks!
-
Approval Workflow and SUMIF Formula
Hi, I have a form individuals submit when they request tickets for an event. Our sheet manager can either approve or decline the requests. If approved, I have a formula set up that removes the amount of requested tickets from the total. The request entry is copied to a separate sheet that has a calendar of each event along…
-
Nesting IF Statements to provide % Complete
Hello All, I have a project sheet with the following status dropdown: Not Started In Progress Ready for Review Complete Canceled On Hold Not Applicable I'd like to write a nested IF statement to provide a value in a percent complete column. I've tried the following but get a #UNPARSEABLE response. =IF(Status@row = "Not…
-
Help with creating Formula's using " Is Blank" and "If"
So, for the first part of the equation, I wanna say " if the contract end date is blank, then the decision date cell will be blank" and the second part of the equation is the decision date column = (Contract End date minus Notice Period) =IF(ISBLANK(Contract End Date@row),COUNTIF([Contract End Date]@row - [Renewal Alert…
-
Using the average and standard dev formula
I am trying to use an average formula to get the average of data from the past 30 days. I tried using collect but seem not to be working as it gives me an error. I also am using standard dev formula both for the past 30 days/data before that row. Please help.
-
COUNTIFS help for future dates
I wanted to create summary tasks for items that are past due and then items that are upcoming in the next 30 days. My Past Due formula is working correctly: =COUNTIFS([End Date]:[End Date], <TODAY(), [% Complete]:[% Complete], <0.1) My Upcoming tasks formula is not: =COUNTIFS([Start Date]:[Start Date], <=TODAY(+30), [%…