-
Is the a function that identifies if a row has an attachment
I want to set a flag (symbol or check box) on a row if that row does not have an attachment. I know I can filter on that, but that is not the whole solution I need. I really need to have something I can count and filter on in reports
-
Mileage reimbursement Help
I have automated an expense report. This worked great as I did an index/match on the date the expense was for, compared to the year, and reported back the mileage reimbursement rate. =IF(ISBLANK(Miles@row), Miles@row * 0, Miles@row * (INDEX({Mileage Reimbursement master Range 1}, MATCH([F*Year]@row, {Mileage Reimbursement…
-
Reference row about in Index?
I have a stagnant formula that color codes projects the same if they are releasing the same week. I want to make the formula dynamic though for when projects move. I've used some other's solutions from this forum but still unable to get this to work. I have a large spreadsheet with projects and a Release Date column. I…
-
SumIfs or Contains or Both forumlas
I am trying to update this smartsheet (1st pic) "Spent Amount" to match another sheet. That means that if Branch 2 is the same Branch name as the 1st smartsheet, then the amount in the "Amount" column, it will update the 1st Smartsheet "Spent" column This is the formula I am using: =SUMIFS({Branch Name}, {Spent amount},…
-
Counting prior month data
Hello, I'm trying to report on prior month data points within a Dashboard I created. I've built a metric sheet off a "master" sheet. I've attached a screen shot of the metric sheet and a screen shot of the master sheet columns. Here is the formula I've been using to capture metrics - it needs to be changed to capture prior…
-
Help with COUNTIFs
I am trying to count the number of payment dates that exist for a client, so I want to count the number of times a cell in a row is not blank. The columns are not contiguous-there is another column between these that I have hidden. You can see in the # of Payments Received column that the formula I have entered is not…
-
SUMIFS problem
I want to sum a set of data using the following criteria: If project Status is "submitted" and Division is "Pharma" I want to sum Est Savings. Here is what I have so far: =SUMIFS({Idea Capture (with Form) Range 1}, [Primary Column]@row, {Idea Capture (with Form) Range 4}, {Idea Capture (with Form) Range 2})
-
Formula to exclude a cell
Hello, I am using Smartsheet to create a scorecard. There is an area where I would like to be able to exclude the cell from the count if it is blank. The current formula I have is this: =IF([17. Voicemail - Follows script accurately]@row = 64, "Pass", "Fail") How can I add so that if it is blank it does not count that…
-
Adding years to date
I've looked through other discussions on this and tried some of the answers but it's not working for me. I have 3 columns and want to add the number of years (which could vary) to a date). My formula in the Next Expiration Date Column is this: =DATE(YEAR([Last Renewal Date]@row + [Auto Renewal Length]@row), MONTH([Last…
-
Creating a dashboard from a sheet with multiple data types
Hey all, attached is a screenshot of a sheet I am trying to create a dashboard with. The issue I am having is creating a chart/view to show completion of a year review meeting by student. The 'Complete?' check box is what we are using to mark completion of the meeting. When I try and make a dashboard from this sheet and…