-
Help with #Unparseable Formulas
Hi Everyone! I am a new Smartsheet user and am having some issues creating formulas that are based off of multiple columns where those columns are set up as drop downs with multiple selections. My Formula: =SUMIFS({Deliverables}, {Work Type} HAS (@cell, Reprint), {Fiscal Quarter}, HAS (@cell, "Q1"), {Fiscal Year}, HAS…
-
return date which is next higher one
Hi, I'm looking for a formula to check the "End date" and return the next higher from date from the reference sheet. e.g. End Date is May 7, the result should be Pre-confirmed 90 LT=May 8 or End Date is June 16, the result should be Pre-confirmed 90 LT=June 26 I have no idea which formula could work. Thanks for your help!
-
Need help in creating Compliance sheet for customer.
For Compliances, the customer tracks items with their deadline dates like Income tax return 20 Sept every year, TDS payment 7th of every month, TDS return by 30th day after end of Quarter. They want once the status is completed, the date should automatically change so the reminders will be on the new dates. Please help on…
-
Formula help! If cell is not blank, return value from another cell
I'm having trouble building a formula that works for the below requirement (see screenshot for reference). If the cell in column 'INT / DOM / TEMP / NG' is NOT BLANK, then I need the column 'TITLE (Formula)' to pull through the value from a specific cell ('A1' in Excel terms, or 'TITLE / Security Title' in the example…
-
Can I submit multiple dates in a form for one event?
I am trying to build a social media content calendar. We have our posting schedule laid out at regular intervals prior to the event. For example, if an event takes place on March 17th then we would have a post going out on March 10th, a reminder going our the 16th, and another post the day of the event. I am using…
-
Multiple If Statements
Nested formulas and I are not friends. This works without putting more than one statement in here, what am I doing wrong and with multiple statements? =IF(OR([How many xyz]@row = "0-3 xyz", "$50-100K")), IF(OR([xyz?]@row = "4-10 xyz", "100-300K")))
-
How Do I Capture The Most Recent Date From One Sheet Onto Another Sheet?
Hello! I am trying to pull the most recent date for a specific project into a cell on another sheet and have it update automatically when a new/most recent date is put in. Ie. The 10/27/23 date is pulled to a master sheet and updates automatically when a more recent date is put in. I was trying to do a bunch of…
-
Update Status Column based % Complete, Finish Date and Today
Hi, I am trying to work out the correct formula so my Status Column updates automatically based on % Complete, Finish and Today's date. I am using this formula for the Progress Column: =IF(Status@row = "At Risk", "Red", IF(Status@row = "Pending", "Yellow", IF(Status@row = "In Progress", "Green", IF(Status@row = "Complete",…
-
Can I use a SUMIF formula to sum children rows?
Looking for help on writing a formula to be located in the Parent Row under the Forecast column Row 1 to sum children rows of all Salesperson except Mike. I manually entered a formula =Value2 + Value3 + Value 5 in the Parent Row (90% Closing) Forecast column Row 1 to get the sum total of $700,000 that I am looking for, but…
-
COUNTIFS function
Hello, I'm using the following COUNTIFS function but it's giving me a zero value. =COUNTIFS(Market:Market, "Austin", [Non-Admit Code]:[Non-Admit Code], "Outside coverage area") What am I doing wrong?