-
stacked if formula based on DATE and Drop down
Good afternoon all I am fairly new to smartsheet but an intermediate user of Excel. For some reason, my multiple stacked IF OR formula for Dates is not working - i know it must be simple but ive been staring at it and really need some help Test Frequency is a drop down list: Daily/Weekly/Monthly/Quarterly/Yearly In a…
-
Date Function not working
Howdy Experts I am trying to get a month number from a date in a corresponding column. I use the function =MONTH([Incident Date]1) but i get back #DATE EXPECTED. the date column has the date format of Jan 11, 2019. I just need the month number in order to run a report based on incidents that occur in their corresponding…
-
SUMIFS, cross-sheet reference based on dates.
Sorry if this is a duplicate. I couldn't find an answer that fit my problem.. Formula: =SUMIFS({AccHours}, {ShipDate}, <=Date3, {completed}, <>"x") All references are from another sheet except Date3. Date3 is a formula as well, which is TODAY()+2. This works in Excel, but doesn't seem to work here. I don't get an error,…
-
Data derived from mulitple criteria
Hello Smartsheet Friends, I have a single text box that I'd like to do some data analysis on, and wondering if there is a way. My text box is similar to the below "Product, Engineering, IT, Supply Chain, etc......." I want to pull all of the instances of "Supply Chain" and do a sumif. Aka total number of submissions for…
-
How to update dates to a new future date
Hi I use smartsheet as payroll check system. I normally maintain a group name, pay date, direct credit date. For some groups we pay weekly and for some we pay fortnightly. How do i automate date column with future date once i complete the payroll on certain date. Example Group Name Payroll preparion Date Direct Credit Date…
-
Predecessor formula
help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 points 3) All tasks that have a predecessor with a task number (which is not completed and overdue by date) This should all be…
-
Feature Request: Static formula's for a column
My Sheets are heavly Forumula laiden and this, in itself creates an issue insofar as each time I create new rows I have to ensure all my formulas are copied from a blank row. I'd love to be able to define a formula inside a column that means that the formula is ALWAYS used whenever a new row is inserted etc.
-
Problem with Index Match
Hi I'm trying to fill out the hours with Index/Match. It works with some but not with other. Here is the formula I'm using =INDEX({Week 19}, MATCH(Matter2, {Matter}) (Image 1) Image 2 - Were data is pulling from On some it works however on other it defaults to the first one. In the 3rd Image I use the formula, =INDEX({Week…
-
RYG Formula
Good Day All: I am trying to add to my formula so that if the Due Date (Actual) is Blank/Empty, the RYG is Blank/Empty. My existing formula: =IF([Due Date (Actual)]3 > [Due Date (Planned)]3, "Red", IF([Due Date (Actual)]3 < [Due Date (Planned)]3, "Green", IF([Due Date (Actual)]3 = [Due Date (Planned)]3, "Blue"))) Thanks
-
countif current month
I was counting for current month. However, I keep getting invalid data type. =COUNTIF({Month}, MONTH(@cell) = MONTH(TODAY()))