-
Changes Report
Does anyone know if there is a way to produce a report or a list of rows whereby Column A has changed in the last n number of days? I'm trying to produce an exec level weekly report of key projects whose end dates that have changed in the last week.
-
Formula help sumif has no children
Hello, I want to sum up every number in a column only if the row has no children. I'm sure there's an easy way to do it, but I've bashed my head up against it and can't figure it out. Many thanks! Geordie
-
COUNTIFS formula with year
I'm trying to put together a COUNTIFS formula for my Sheet Summary that will count the number of items that are shown as Completed in the status column along with what year they were completed in. Looking at other discussions, I found this: =COUNTIFS([NVAP Phase/Status]:[NVAP Phase/Status], "Completed", [NVAP Completed…
-
populate a field based on if a due date is x days or less.
anybody by chance know what is the easiest way it possible to set up a formula that reads a field to auto populate a date that is say 10 days before another date (due date)
-
Priority Rating with Formula Logic
New to smartsheets and the Formula and I am basically trying to set up a priority rating system. There are 4 priorities and 4 questions. If all questions are answered yes and the one checkbox is check then it gets a rating of P1 but if 2/3 questions are yes and the checkbox is checked then its p2 and so on and so on. I am…
-
IF statement
I am working on a sheet and want to incorporate an IF (or maybe an IF AND) statement based on the date items are submitted to them for review, which is one of the date columns in the sheet. Here are the conditions I want to test: 1) If today is less than or equal to 3 weeks from the submission date, turn the RYG ball…
-
Count dates and return a valve from another sheet
I need to reefer to another sheet and count any row that has a "Fill Superintendent" and return a number if it is =< today in column. Then a valve if its => 60 days Thank you for any help
-
CONTAINS, MATCH, INDEX Help
I'm trying to use CONTAINS, MATCH, and INDEX in cross-sheet formulas to pull location-specific system component inspection information from invoices to my asset register. Sometimes, the invoices will have more than one system component on them. I want to make sure the formulas will pull the information for each of the…
-
Function Help
Hello, I have a sheet set up with a form to track historical data for collections efforts daily. On the Summary tab I'd like it to be able to display today's stats. I'm not sure what function to use to make this happen. How it is set up is column "A" is the date and column "B" is a percentage. I would like the summary to…
-
Allow a cell to only be certain days of the month
I put together schedules that include public hearing dates that are typically certain days of the month , i.e. 2nd Tuesday, is there a way to assign this to a cell in my schedule? Currently I have to go to that point in my schedule and manually find the date and each time the schedule changes I have to make sure I update…