-
Run report for current month
Let's say my task sheet has dates that tasks are created - not necessary TODAY. And I want to run a report if the created date is this month. For example, Task A's created date is 09/10/2017, and this month is September. The report should pick up Task A if I run report today, but next month. How can I achieve this? I made…
-
Formula Help (does not contain)
Columns "Risk" "Start Date" "Part Status" I want "Risk" to FLAG, if "start date" is TODAY or > and "Part Status" is NOT "shipped" or "in progress" I have the formula below for if start date is today or > =IF(ISDATE([Start Date]4), IF(AND(TODAY() > [Start Date]4), 1)) How can I combine AND if "Part Status" is NOT "shipped"…
-
Adding to an Existing Conditional Formula: Date Field
Good Day All: I am trying to add to my existing formula if the date is not populated the harvey ball will remain yellow. If all conditions are met (date submitted, date approved, approved by committee, and Delivery date) then green All help greatly appreciated, Thanks! Existing Formula: =IF([Approved by Committee]2 = 1,…
-
Help with a formula
Greetings, First time posting because I'm not well versed with formulas and I'm hoping that someone smarter than me can offer some guidance. I would like to create a form that assigns a point value to specific activities (e.g. JTA, IDW, SS, TR and so on) identified in different columns and sums the total value of all…
-
Using LOOKUP function on a sheet with a form to add rows
I am having some trouble with using the LOOKUP function on a sheet I have. We want to use a form to create a ad placement name that includes abbreviations of what the user selects. I am finding that the LOOKUP area shifts as new rows are added. I set all my lookup tables at the top of a sheet and then the new rows are…
-
SUMIF - Circular Reference?
Hello all! I'm pretty sure I saw this functionality in one of my Engage sessions, so I'm crossing my fingers that there's a simple fix! I'd like to create a form that would allow individuals to submit project-related expenses for approval. I envision having a list of project numbers at the top of the sheet (see image, with…
-
Add a column showing the ParentID (or SiblingID)
Hi all, Is there a way to add a column which displays the ParentID to a Smartsheet? If I had this, I could produce the report I am trying to build I expect. Hep appreciated! Thanks, James
-
Notification with attachment
Hi, I have already set up the notification. In my Smartsheet, there are a few columns. One of column is "Mail Out". In this column, pre-set has two answer only: yes , no. In each row, there is an attachment of that specific building word file. So, as I create notification, if mail out column is "yes", email to mail room…
-
Show Value Sum of total Parent Rows checked.
I've researched this and cant find a solution. How can I set up a CountIf formula for ONLY if Parent Rows are checked in an entire sheet? I can do this for the children rows but cant figure out how to do it only for Parent rows. Also, Can I place this formula on the checkbox column (at the very top for a total) and show a…
-
How to compute Average Ratings on a Subset of Rows
Trying to put a formula that will compute the average rating based on organizational grouping. I have a smartsheet that has a drop down field which includes organization functions like: engineering, IT, Sales, Marketing, ... I have another field that is a numeric rating for these organizational functions. 1 thru 5. I need…