-
COUNTIF between Dates
I have a formula (see below) where I'm trying to get a count where multiple criteria apply. The first date range renders a correct count but fails once the second one is added. I've tried multiple iterations of the formula, this is my current one. If it is not clear from the formula, I'm trying to count tasks assigned to…
-
Using MONTH formula with a blank date cell
I have been using the month formula to create a month number from an 'Actual close date' column. however i get error when the source column 'Actual close date' is blank I can get the month number to work when dates are included with =MONTH([Actual Close date]4) and I can clear away error message if source is blank with…
-
Rollup Formula
I have a rollup sheet. I am needing a cross sheet formula to calculate total quote for a specific sales rep. See screen shots below. Thanks so much your help. I really do appreciate it!
-
Formula Help - Completed Projects Within FY
Hi there, I am looking to include a metrics widget on my portfolio dashboard for all completed projects in FY20. Our fiscal year runs 2/1/19 through 1/31/20 (or alternately, this could just be completed projects in Feb 2019 and after, then I will start a new count next Feb). My current baseline formula…
-
Monthly Turnover Time
Hello, I am working to create a widget on a dashboard. In order to do this, I want to get data between a start date and end date (turnover time) per month to show monthly progress. I have tried by finding the month and year but I'm not sure how to attach the turnover time days with its corresponding month/year . . .…
-
Nested IF & Multiple arguments
Hey there! Currently trying to automate a tracking report that my company uses. I want the "District" column to automate based on the property number entered. However, while there is only 7 districts, the list of properties could easily be in the thousands. We can determine the district of a property by the first two…
-
No Array formulas but need work around
Smartsheet does not use array formulas, but I need a way to list out items from one spreadsheet to another if a certain condition is met. For example, I have an array formula that I used in excel that would look for a certain condition on one spreadsheet then pull all the rows of data that had that condition to another…
-
Updating RYGB status based on date AND dropdown selection in multiple columns
Hello! I would like for the RYGB status to be updated based on BOTH a due date (I already know how to do the status based on only due date), AND on the selection of a drop down menu in 5 other columns. So: Red is past due AND "completed" or "N/A" are not selected in the drop down menu in multiple columns. Green is past due…
-
Cross sheet formula help
I have a master property sheet that is updated with new property information. One of the columns in the property information sheet is "Sales Rep." I created another sheet that I want to track the list of properties for each sales rep. 1 sheet is setup for each sales rep. I would like for the tracking sheet to pull all of…
-
Creating a 2nd date calculated from initial date
Added data in row with a created date I want to automate an expected close date 30 days from created date.However the expected close date could move and I want to be able to change that days adding on days until actual becomes yesterday. of this I want to run forcasting into months and length of sell cycle. I have read…