-
Formula Help - Automating Status
Hi there, I am wondering if its possible to use a formula to automate aย status column.ย For example, when someone submits an intake request through a form and a new row is added to my sheet, is it possible to haveย the statusย automatically change to "Intake"? Further, when someone approves the intake (i.e. Laura Approvalโฆ
-
Looking for Formula Help
In my sheet, I have two columns. One entitled "Hotel Check-In Date" and the other "Hotel Check-Out Date". So someone might input: Check-in 11/20/19 and out on 11/25/19. I know have individual columns for each date: i.e. 11/20, 11/21, 11/22, 11/23, etc. I am looking for a formula that will be a value of "1" in the correctโฆ
-
Formula Error - Sumifs
Hello, I'm trying to build out a SUMIFS formula that adds up timesheet data from a separate data sheet using 4 criteria: employee name, project code, start date and end date. The formula works fine if I don't have criteria for project code. As soon as I add another criteria to match the client code, I get an #INCORRECTโฆ
-
formula help - sum if blank
I'm trying to run a formula to sum the numbers in a netdays row if another column is blank and am running into issues. Here is the formula that I have: =SUMIFS([Requested - Complete]81:[Requested - Complete]452, Q81:Q452, "1", [Survey Required]81:[Survey Required]452, "") Any help on what I am missing would be appreciated.ย
-
Can't identify my Formula error
Can anyone suggest what is wrong with my formula? I get an #INVALID OPERATION result. I've looked at it for too long and can't find the issue. Thanks. =IF(NOT(ISBLANK([Order Date]1)), "Ordered", IF([READY TO ORDER]1 = 1, "Ready to Order", IF([CPM Complete]1 = 1, "CPM Need Approval", IF(NOT(ISBLANK([Vendor Quote requestedโฆ
-
Error in WEEKDAY formula
I'm struggling with a formula that seems to be broken. I created a timesheet that has a cell that looks at the Auto Date/Time stamp and calls up the weekday. The formula is as follows: =WEEKDAY([Date/Time]129) It works great...unless the timestamp is 5:00PM or later. Then it results in the next day. So if the timestamp isโฆ
-
Return top 5 occurrances
I have a sheet to track customer requestsย (500+ rows), with a Salesperson column and customer column, the salesperson column is located farthest to the right of the sheet whereas the customer column is located on the 1st column. What I want to do is write a function that will referenceย a given Salesperson contact and beโฆ
-
Function Help - Sheet References
Hi there - I am working on building a slightly better project tracker for our organization. We currently utilize calculated fields that we have to define for each new project, and sometimes the project does not have enough project rows to account for all items we are tracking. I need help with a specific formula that wouldโฆ
-
IF then statement
Hi, Fairly new to smartsheet, I am looking to do the following: If 'Drop Down A' is set to 'No', then set 'Date Column B' = 'Date Column A + 30' If 'Drop Down A' is set to 'No', then set 'Date Column D' = 'Date Column A + 14' If 'Drop Down A' is set to 'No', then set 'Date Column E' = 'Date Column A + 7' Appreciate theโฆ
-
Return 1 if YEAR and MONTH is equal TODAY
Hi, I have a formula: =IFERROR(IF(MONTH([Sale Date]2) = MONTH(TODAY()), 1, IF(MONTH([Saleย Date]2) = MONTH(TODAY()) - 1, 2)), " ") and it worked until we have two years in one sheet. I would like to know how to add YEAR to this formula so that we can compare not only MONTH but also YEAR. Thanks.